| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using comma inside the comma delimited text in Data Validation/Sou
This works fine:
Selection.Validation.Add xlValidateList, , , "10000,20000,30000" How do I use comma INSIDE my items in the list, fx. if I want the list to contain: 10,000 20,000 30,000 One would assume that the following would do the trick, but it doesn't: Selection.Validation.Add xlValidateList, , , "'10,000','20,000','30,000'" Any idea on how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Import comma delimited text | Excel Discussion (Misc queries) | |||
| I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
| Comma Delimited Text File Issue | Excel Programming | |||
| Comma delimited text to columns | Excel Programming | |||
Threaded Mode
