ExcelBanter - data validation (multiple options)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - data validation (multiple options) (https://www.excelbanter.com/excel-programming/417545-data-validation-multiple-options.html)

MJKelly

data validation (multiple options)

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

[email protected]

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

All times are GMT +1. The time now is 01:56 PM.