Hello.
First of all - I have very little VBA training, but am trying to modify some existing code! I have programming experience so am not totally new.
I'm looking for VBA code to help with the following:-
In cell A1 I have a data validation list of options, say "Mouse,Cat,Horse,Human,Dog,Ape".
In cell B1 I want to force a selection from another data validation list say "Anna,Bob,Chris,Doug,Erica" - but ONLY if the value in A1 is = "Human". If it's anything else I want nothing.
I don't want anything in B1 UNLESS A1="Human".
I believe I need some code in the Worksheet_Change Sub routine with a CASE statement which would pick up when A1 has changed.
I feel it should be straightforward, but as I say, with only little knowledge I don't know where to start.
The key thing is the FORCING of a selection in B1 if A1 is selected. I've seen various websites (Contextures etc) which talk about data validation on multiple columns, but nothing about making the selection mandatory.
Thank you.
Bookmarks