Drop-down list and error message

C

charlene

Hi,
I have a question concerning drop-down list and error message. I have two lists (range name: Status1 and Status2), the lists to be shown in cell A1 depends on wether cell B2 is empty or not (in B2 user can write what he wants, no drop-down list).
To create the drop-down list in cell A2 I wrote the following: =IF($B9="",Status1,Status2).
It works fine. The problem I encounter is the error message not showing up if the user enters in A2 a value that doesn't correspond to list items (although the box for error is checked). Actually when B2 contains a value and then I enter a value in A2 that is wrong, the error message appears, if B2 is empty, any value can be entered (no error message) althoug only items from Status1 should be accepted.
I don't understand what's going on.
Thanks for your input !
 
G

GS

Hi,
I have a question concerning drop-down list and error message. I have
two lists (range name: Status1 and Status2), the lists to be shown in
cell A1 depends on wether cell B2 is empty or not (in B2 user can
write what he wants, no drop-down list). To create the drop-down
list in cell A2 I wrote the following: =IF($B9="",Status1,Status2).
It works fine. The problem I encounter is the error message not
showing up if the user enters in A2 a value that doesn't correspond
to list items (although the box for error is checked). Actually when
B2 contains a value and then I enter a value in A2 that is wrong, the
error message appears, if B2 is empty, any value can be entered (no
error message) althoug only items from Status1 should be accepted. I
don't understand what's going on. Thanks for your input !

Try...

=IF(LEN($B9),Status2,Status1)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top