dropdown list question

K

keithb

I am using an in-cell dropdown list that is populated from a vba string. I
have encountered a 255 character limit for the list of lookup items. Is
there any way around this other than using spreadsheet cells to store the
list values?

Thanks,

Keith
 
D

Debra Dalgleish

The data validation list can come from a delimited list or a worksheet
range. You could store the list on a hidden sheet, if you don't want
users to accidentally change it.
 
Top