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