Hello...this should be simple but it's annoying me trying to figure it out. I created a userform with 2 comboboxes. How do I specify what the drop down for the combo box is? I want it to be a range of cells...also I want ComboBox1 to populate after they hit submit button to cell C2 and ComboBox2 to populate to E2. One last thing I want this to basically force the user to submit this info so I want the X button in the top right corner rid of or disabled and I want the userform to open when the workbook is open (that part I figured out how to do). Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Userform on open of workbook with comboboxes as input
- Thread starter Ace71425
- Start date
-
- Tags
- combobox open event userform
Excel Facts
Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Similar threads
- Replies
- 2
- Views
- 368
- Replies
- 0
- Views
- 163
- Solved
- Replies
- 20
- Views
- 781
