How to run a Macro from a vba script

Hi all,

I have a macro which works great but i need away to make it run when cell a1 value changes to 2. But i only want it to run once untill the next time a1 changes to 2 again, my biggest issue is that a1 could have a value of 2 for some seconds and I don't want the macro to keep running untill the value changes. Cell a1 also has a formula in it.

Thanks in advance

It looks like an interesting, but unfortunately hardly comprehensible problem, because you omitted to post a sample workbook, containing that well functioning macro.

Maybe

Please Login or Register  to view this content.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

How was it resolved & please mark solved

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save