VBA: To run macro based on selected dependent drop down list

woofie

New Member
Joined
Mar 8, 2016
Messages
8
Hi fellow coders,

To begin with, I am very new to VBA.

Firstly, I want all of these to be incorporated on a popbox menu (similar to a userform).

In that form, I want to select a list of options (from multiple drop down lists) and hit a command button to execute based on the selected options from the various dropdown list.

Here are the different dropdown list that I require.
  1. Select the Type
    1. Option A
    2. Option B
  2. Select the Index (applicable to either option selected in Dropdown1)
    1. Option C
    2. Option D
  3. Select the Category
    1. Options C1 to C5 (if select C in Dropdown2)
    2. Options D1 to D5 (if select D in Dropdown2)
  4. Frequency (will only appear if selected B in Droplist1)
    1. Monthly
    2. Yearly
  5. Period (will only appear if selected B in Droplist1)
    1. 2000 to 2015 options (if select Monthly in Droplist4)

So upon choosing all the relevant dropdown, there is a button for me to click to run the macro based on the unique combination of the relevant dropdown. That being said, I actually have a lot of macros recorded for each combination. :LOL:

Hope some kind souls out there can give me some tips to go about doing it. Thanks in advance! ;)
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,122,987
Messages
5,599,210
Members
414,296
Latest member
nachname

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top