Using formulas to trigger macro

**MyOnion** · 06-20-2013, 06:24 AM

Hi,

I was wondering, if it is possible to use formulas to trigger macro e.g. if A1 = 1, use macro 1 and if A1 = 2, use macro 2 and so on...
I have heard that the IF formula can do that but not sure if its true.

**NickyC** · 06-20-2013, 06:37 AM

you can do this using a worksheet change event

right click on the sheet's tab, select view code and paste this:

Please Login or Register  to view this content.

**:) Sixthsense :)** · 06-20-2013, 06:38 AM

Your question seems to be similar to this OPs requirement, just have a look in the below thread and check whether this helps

http://www.excelforum.com/excel-prog...unmacro-y.html

**MyOnion** · 06-20-2013, 10:44 PM

Hi all,

I am sorry as I would have to try this after my problem with macro and relative reference are fixed.
Or maybe I can just create a few simple macro and try later today earliest.
I will update/reply to this thread after I have tried the suggestions mentioned here. Thanks Sixthsense and NickyC. (No reps until I try! xD)