View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MichaelZ MichaelZ is offline
external usenet poster
 
Posts: 19
Default Dropdown lists from datavalidation.

In cell B9 I have a dropdown list of health-related questions that a user can
select from.
In cell B10 I have a dropdown list of more specific health-related questions
that a user can select from.
What I'd like to do is, if the user chooses one of the questions from the
dropdown list in cell B10, I'd like the contents of cell B9 to be blank. How
can I do this? Thanks in advance.