Controlling User Input

[Jeremy]

Hi,

Does anybody know how to restrict a user from entering
anything but one of two possible letters (either A or R)?
I've used validation to allow the cell to only accept a
single letter, but I don't know how to limit input to only
A or R.

On a similar note, is there a way to prevent users from
pasting over data validation and thus rendering the
validation useless?

Any help is appreciated.

Jeremy

 

[Earl Kiosterud]

Jeremy,

Data - Validation - List:

a, r
a, r, A, R

 

[Frank Kabel]

Hi
within the data validation dialog choose 'List' and enter
"A","R"