Question on using a Drop Down Menu.

  • Thread starter Thread starter turtlegalaxy
  • Start date Start date
T

turtlegalaxy

I want to creat a drop down menu with 4 options people can pick from. If
they pick one of the options I need more details. Is there a way to set it
up so that if someone picks the option needing more detail a new cell will
automatically appear, and not let them move forward until they have entered
details?
 
You need VBA for this because you want to prevent them from doing anything
until they enter the appropriate detail. However, if there is not particular
detail they need to enter, just to enter something, then you really aren't
controlling them. You could move them to the adjacent cell where you could
have a second drop down which would have the appropriate choice based on the
item selected from the first drop down.

Is VBA an acceptable solution and does the above meet your needs, that is do
you have a list of details for them to pick from after they make the first
choice?
 
You must log in or register to reply here.

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

Similar Threads

Creating drop downs in a cell contingent on another drop down 1
Drop down list 2
Select drop down menu option using libre-calc macro 0
Excel Drop Down Box 2
Data-Validation -List - Pick from a drop down menu 4
Restrict Choice in Shared WB (drop down alternative)? 0
Excel Drop Down List 3
DROP DOWN LIST 3

Back
Top