Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Restrict Data Entry to only 4 possible entries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ph8 - 21 Mar 2006 15:37 GMT
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 :)
Tom Ogilvy - 21 Mar 2006 16:13 GMT
select  D4:F6
do data=>Validation

select LIST

enter
X,x,O,o

(no double quotes)

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

Signature

Regards,
Tom Ogilvy

> Hey folks,
>
[quoted text clipped - 11 lines]
> 3x3 square have to be either an X or an O (case irrelevent).  Yup, you
> know what that means.  TicTacToe :).
ph8 - 21 Mar 2006 16:25 GMT
Thanks for the quick response!

Unfortunatly though that wasn't exactly what I had in mind.  That rout
would display an error message when something other than X/O wer
displayed, but would still leave the incorrect data in the cell.  Plus
I was hoping to avoid having the pop up message, as that could probabl
get annoying
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.