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?

--
Cheers,
Shane Devenshire


"turtlegalaxy" wrote:

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?