|
|
#30
07-08-2020, 05:15 PM
|
||||
|
||||
kevin
The examples used a comma delimiter but you could use any (non-used) character you wanted as the separator. If you wanted to change to something else you could eg Code:
StrOut = "bananas|watermelon|oranges, apples, and pears" For i = 0 To UBound(Split(StrOut, "|"))
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dropdown list, Macro | shield5 | Excel Programming | 7 | 10-27-2013 01:51 AM |
| VBA: How to place dropdown list next to text | YigalB | Word VBA | 0 | 08-11-2013 01:48 PM |
| block selection in dropdown list | Intruder | Excel | 2 | 01-10-2013 10:20 AM |
 dropdown list for documents
|
r_p_t_0 | Word | 2 | 12-18-2012 05:55 AM |
| Dropdown list of email addresses | J Partridge | Outlook | 1 | 01-13-2011 06:37 AM |
Windows 10 
Office 2016
Threaded Mode