Chose what Macro to Run

[Anto_BT]

I have 12 Macros "Sub testSQL1()" , "Sub testSQL2()" , "Sub testSQL3()" ....

I want When in cell C1 is January then to Run "Sub testSQL1()"
If it is February then to Run "Sub testSQL2()"
If it is March then to Run "Sub testSQL3()"
... until December

Macro need to Run on Button

Thank you very much

[alansidman]

You can probably achieve this using the Case function in VBA

Look here: http://www.techonthenet.com/excel/formulas/case.php

[ragavan.sridar1]

try this..

Please Login or Register  to view this content.

[Anto_BT]

Thank you very much,
I am sorry I have one more question
In C2 I have year how can i put to see that too
So Month and Year

[ragavan.sridar1]

give this a try..

Please Login or Register  to view this content.