Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Data Validation Options | Excel Discussion (Misc queries) | |||
data Validation options | Excel Worksheet Functions | |||
Data Validation - Multiple Options | Excel Discussion (Misc queries) | |||
data validation - select multiple options? | Excel Discussion (Misc queries) | |||
Data Validation - mixture of options | Excel Discussion (Misc queries) |