Run Macros from Multiple Drop down lists in same sheet

Hi there,

I would like to be able to run different Macros from about 4 different drop down lists in one single sheet. I am using the following code to run from a single drop down list.

Please Login or Register  to view this content.

How can I run more macros from other drop down lists located in other cells in the same sheet.

Any help on this issue would be greatly appreciated,

Regards,

James.

Hi James,

You can hopefully try a Select Case routine, such as the example provided below:

Please Login or Register  to view this content.

Change the cells to your cell references and replace the MsgBox's with your code. You can have as many Case statements as you need, and you should typically use a Case Else as your last statement just in case the rest don't return a result.

"No such luck.." doesn't give any of us a clue as to WHY my suggestion didn't work. Please either give more details or post a copy of your spreadsheet (must be zipped first) and let us know exactly what you're attempting to do.

Hi Thanks for your help so far, it is much appreciated.

I am working with an array of data that can be filtered by many columns and criteria. What I need to do is be able to select from a drop down list and run and macro based on a selection.

I can do this fine if I only run one drop down list per page. The problem I am having is working out how to use 2 or more drop down lists and select an option from it and run a macro to filter the results.

At present I am using this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$7" Then
If Target = "30" Then
T_30

but as you can see this only refers to A7. What I need is the ability to have other cells which contain drop down lists to be part and have the ability to activate a macro.

I did try your code, and your instructions and it doesn't attempt to execute the macro.

If you have any ideas of, I would be fond to hear of them.

Many Thanks,

James

Seeing as it's now 11:30pm and I have to get some sleep before meetings in the morning, perhaps someone in another time zone can assist you with this for now. Thanks for providing more information.

Firstly please read forum rules below and reply confirming you have read them otherwise post will be deleted.

I wrapped your code in post 1 and will move to programming as per rules.

Now can you explain why pjoaquin didn't work as he requested in post 4.


VBA Noob