dropdown list question

  • Thread starter Thread starter keithb
  • Start date Start date
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
 
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.
 
Back
Top