View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] joshuafandango@dsl.pipex.com is offline
external usenet poster
 
Posts: 21
Default data validation (multiple options)

Hi Matt,

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

Cheers,
JF

On 24 Sep, 13:13, MJKelly wrote:
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