Restrict Data Entry to only 4 possible entries
 

Hey folks,

Anyone know of a way to restrict data entry in a cell to one of onl
four total possibilities? More specifically, is there a non-vb
solution to restricting users from inputting anything into a cell wit
the exception of:
x X o O

These are lower and upper case of both the letters X and O (not Zer
the Number). The particular range (if it matters) that I need thi
restriction in place is D4:F6.

If you'll notice, the range is a 3x3 square. The charactors in tha
3x3 square have to be either an X or an O (case irrelevent). Yup, yo
know what that means. TicTacToe :)

--
ph
-----------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...fo&userid=1987
View this thread: http://www.excelforum.com/showthread.php?threadid=52479

Restrict Data Entry to only 4 possible entries
 

Select D4:F6 and do Data=Validation

select List

then enter
X,x,O,o

(no double quotes)

Uncheck "incell dropdown" if you don't want the dropdown arrow to appear.

--
Regards,
Tom Ogilvy

"ph8" wrote:


Hey folks,

Anyone know of a way to restrict data entry in a cell to one of only
four total possibilities? More specifically, is there a non-vba
solution to restricting users from inputting anything into a cell with
the exception of:
x X o O

These are lower and upper case of both the letters X and O (not Zero
the Number). The particular range (if it matters) that I need this
restriction in place is D4:F6.

If you'll notice, the range is a 3x3 square. The charactors in that
3x3 square have to be either an X or an O (case irrelevent). Yup, you
know what that means. TicTacToe :).


--
ph8
------------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871
View this thread: http://www.excelforum.com/showthread...hreadid=524790