Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation problem.
I'm building a comma delimited string through VBA to add a data validation
list to a cell. However, I can only seem to get a max of 255 characters to be recognised and populate into the list. Any ideas of how to get around this at all please, or any advise on how to get the list to populate wioth more characters. TIA. |
#2
|
|||
|
|||
Data Validation problem.
Put your list on a worksheet. Then use that range in the data|validation
dialog. Debra Dalgleish shows how at: http://contextures.com/xlDataVal01.html#Name DaveO wrote: I'm building a comma delimited string through VBA to add a data validation list to a cell. However, I can only seem to get a max of 255 characters to be recognised and populate into the list. Any ideas of how to get around this at all please, or any advise on how to get the list to populate wioth more characters. TIA. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Data Validation | Excel Discussion (Misc queries) |