data validation (multiple options)

M

MJKelly

Hi,

I have range which requires validating, but the allowed inputs are
whole numbers 1 to 2000 and "SL", "AL", "UA" and more.
Can validation cater for this? I don't want to write code to check
the input unless there's no other way.

Kind regards,
Matt
 
J

joshuafandango

Hi Matt,

Not a pretty solution but data validation will accept a list - obv
this means a big list in this case.

Cheers,
JF
 
Top