Automating Form Elements Based on Selection Criteria

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

I am trying to create a form where the fields available change depending on
the value the person chooses from a drop-down menu on the top. What I
envision is hiding rows based on the value. I've searched all over MS Office
help, and I can't seem to find anything like this. Is there a way to set up
this type of automation?

Thanks in advance for your help,

Amanda
 
Thanks for your suggestion. This is pretty neat, but it's not quite what I
am looking to do. My spreadsheet isn't a database, it's a form. I want the
user to be able to select a value from a drop down list, and then for Excel
to automatically hide specific rows based on the value selected.
 
Back
Top