data validation (multiple options)

  • Thread starter Thread starter MJKelly
  • Start date Start date
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
 
Hi Matt,

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

Cheers,
JF
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple validation 4
Data Validation blanks for formulas 18
validated, stop all calculations on bad data 1
Data Validation. Multiple. 4
Data Validation - copy/paste 3
Data Validation for % input in userfom 8
Using Data>Validation cell formatting to drive OnEntry/Intersect m 1
Worksheet protection prevents Data Validation code from running... 1

Back
Top