Cell Validation limits

[Weaver]

If you're creating cell validation using a list and the list comprises of a string entere into the box in the wizard, is there a finite limit to the number of characters you can place in it?

 

[Andrew Poulsom]

Yes, there's a limit of 255 characters.

 

[Weaver]

lol - I had to ask, since someone at work asked me why some code they'd written wouldn't work - they were trying to add a 20,000+ character string! Obiously I knew that was going to overload it but I was guessing 1,024

 

[RoryA]

In 2010, 8192 appears to be the limit if you set it in code.

 

[Weaver]

In 2010, 8192 appears to be the limit if you set it in code.

That figures - the original code was written on 2010 but with a smaller subset of the data. A 255 limit would've broken it at this stage, but it could easily have come in under 8192.

I'm not keen on doing it this way for anything more than a couple of dozen entries, so I was kind of glsd it didn't work. We're compiling a list in a hidden sheet now, naming it and referencing the named range.