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! ;)
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,008
Messages
5,834,852
Members
430,324
Latest member
bosphoruskid

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