Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I restrict data entry to one of two columns but not both? | Excel Discussion (Misc queries) | |||
How do I restrict data entry to one of two columns | Excel Discussion (Misc queries) | |||
Restrict Data Entry to only 4 possible entries | Excel Programming | |||
can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
Excel2000: Data Validation to restrict entries | Excel Discussion (Misc queries) |