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. |
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 |
All times are GMT +1. The time now is 01:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com