returning values from multiselect list as string

M

Michael Chang

I have a multiselect listbox with ListStyleOption 1,
containing the following values: Mondays, Tuesdays,
Wednesdays, Thursdays, Fridays.

I would like to return the user's selections in a string
separated by commas with an "and" before the final item.
For example, if the user selected Mondays, Wednesdays and
Thursdays I would like myString to be "Mondays,
Wednesdays and Thursdays".

Any ideas?

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif w/semicolon separated values 4
Countif w/semicolon separated values AND Filter 1
Search closest day in the past from today 2
conditional format of adjacent cell with different range and crite 1
Wrong values when a vacation day is taken 5
Calculate time differential - Mon - Fri workday basis 3
Need Function Help 8
How can I use OFFSET and VLOOKUP together 1

Top