| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to get a User Form to activate off a drop down menu
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to get a User Form to activate off a drop down menu
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? Rcarper wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to get a User Form to activate off a drop down menu
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 "Dave Peterson" wrote: 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? Rcarper wrote: 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. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Drop Down for User Form | Excel Discussion (Misc queries) | |||
| User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
| How to activate disappeared menu bar | Setting up and Configuration of Excel | |||
| how do you activate the right click drop down menu in Excel? | Setting up and Configuration of Excel | |||
| how to activate a drop down menu in spreed sheet with space bar? | Excel Discussion (Misc queries) | |||
Linear Mode
