data validation

[Guest]

In cell A1 users are required to enter either 0,1 or 2. Firstly how do I make
this cell only accept these values and secondly, if they enter 1 (not 0 or 2)
I need B1 to become a listbox, listing two options.
Can anyone help please?

I would like B1 to be blank if they put a 0 or 2 in A1

 

[Anne Troy]

You need what many call Conditional Dropdowns. Check out my recent post
here:
http://www.vbaexpress.com/forum/showthread.php?p=31212#post31212

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

Had a look at conditional formatting, but doesn't seem to allow you to
constrain a cell to 0,1 and 2 values, also it doesn't help with the showing
of the listbox in B1 (or am i doing something wrong).
Can't access your link

 

[Bob Phillips]

I think Anne meant data validation not conditional formatting, see
http://www.contextures.com/xlDataVal01.html

And CF does allow multiple values. Change the condition to FormulaIs and use
a a formula like

=OR(A1=0,A1=1,A1=2)