Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restrict data entry in a cell | Excel Worksheet Functions | |||
Restrict Data Entry to only 4 possible entries | Excel Programming | |||
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) |