Limiting a cell to the choice of "yes" or "no"

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have looked at the list box and forms and cannot figure
out how to restrict the cells in a column to the choice
of "yes" or "no". I am creating a sheet for other to use
and the choice in come cases is only yes or no.
 
Pat have a look at data validation, use list yes,no

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Given that validation allows pasting of another value it is not foolproof ,
however if you select the cells, then do data>validation, allow list, in the
source
type

yes,no

uncheck in cell dropdown unless of course you want to let them select from
the dropdown

Click OK (you can add a heads up message saying that they need to choose
between the 2)
 
Pat,

Look at data validation, it's easy to restrict to Yes or No. Debra Dalgleish
has a good explanation on her site www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Pat,
In F1 type Yes; in F2 type No
Go to A1:A10; use Data|Validation; select List; in the Source box enter
F1:F2; click OK
Now in A1 thee is a dropdown box with Yes and No as the options.
Reselect A1:A10, use Data|Validation and add an Error Alert message
Best wishes
Bernard
 
Back
Top