Trying to get a User Form to activate off a drop down menu

R

Rcarper

Hello,

I'm working on a sheet that will have a drop down menu with three options.
Each option is expected to open a respective user form that has secondary
options within it. Is this possible? How do I do this?

Thank you for your time and effort.
 
D

Dave Peterson

How did you create the dropdown?

Did you use Data|validation?
Did you use a combobox from the control toolbox toolbar?
Did you use a dropdown from the Forms toolbar?

What is the string for option 1? What is the name of the userform?
What is the string for option 2? What is the name of the userform?
What is the string for option 3? What is the name of the userform?
 
R

Rcarper

Thank you for the questions

1.) I think I'd use Data Validation by using a list and assigning to cells.
2.) No
3.) I think so. Used the Drop down straight from Excel

4.) I think you mean the name...But its Class E2 User form might be named
the same. Sorry I don't program well.
5.) Its Class 1
6.) Its Class 2
 

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

How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Microsoft 365 Activations, Users or Devices? 0
Filtered drop down list 2
Using Drop Down list to an If Statement to another Drop Down list 3
ASK Field Formatting 1
Help with drop down selection and populating related data... 9
Documents from shared model are created with design mode on 1
Using a Drop Down Menu 1

Top