Good Day~
I have a form with two listboxes. Each list box is based on a query and changes values when selection is change. Only the first column is visible and there are 3 more columns I get values from to update a table. I need a vba code to get one listbox column values so I can put it in a sentence. If there is only one staff member I want to save one, if there is two I want to save want to put "and" between the first one and second one (John Doe and Jane Doe), or if there are 3 or more I want commas between and "and" at the end (John Doe, Jane Doe, and Sally Doe).
Please help.
Thank you in advance~mjc
I have a form with two listboxes. Each list box is based on a query and changes values when selection is change. Only the first column is visible and there are 3 more columns I get values from to update a table. I need a vba code to get one listbox column values so I can put it in a sentence. If there is only one staff member I want to save one, if there is two I want to save want to put "and" between the first one and second one (John Doe and Jane Doe), or if there are 3 or more I want commas between and "and" at the end (John Doe, Jane Doe, and Sally Doe).
Please help.
Thank you in advance~mjc