Execute macro based on cell value

Hi,

I have a combo box on Sheet5 where the user chooses one of two options. The combo box spits out "1" or "2" in cell AA7. Then I have two macros: "SPOR" and "Avg_Chk", which change a bunch of calculations on the sheet. I would like the "SPOR" macro to be executed if the value in AA7 is "1" and the "Avg_Chk" macro when the value in AA7 is "2".

I googled and found lots of answers and solutions for this, but when I try to apply them to my worksheet nothing happens when I change the combo box. This is the code I found:

Please Login or Register  to view this content.

I add this to the code of Sheet 5. Macro "Spor" and "Avg_Chk" are saved in a module.

My apologies, I know little to nothing of VBA. I'm sure this is a very obvious mistake and I'm sorry for my noobishness :D

Thank you for your help!

Cheers

M.

Please Login or Register  to view this content.

Originally Posted by ptmuldoon

I think you need to actually Call the Macro

It looks like the problem is with the combo box and not with the macro itself. Selecting the different choices in the combo box accurately updates the value in AA7 to "1" or "2". Problem is the macro does not recognize that as change. If I type "1" or "2" in AA7 on the other hand, it triggers right away.

Thank you for your other suggestion. Unfortunately I have 0 experience with Userforms. I had a look at my VBA and there is a userform1. I copied your formulas from above but it didn't do what I was hoping it would. What am I doing wrong? ^.^

Thanks!

M.

My bad, I thought you were referring to a dropdown using data validation, since you were using the Worksheet_change event. You may have to consider worksheet_calculate.

Not sure what type of combo-box you are using though.