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

[woofie]

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.

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

 

[woofie]

bumpz....