Initialize macro

[Tom Jung]

How do I initialize a macro to run when a cell value changes, the targe
cell contains a reference formula, with either a "0" or "1" as th
result, IU want the macro to start when the result is "1"

 

[Norman Jones]

Hi Tom,

Try:
'============>>
Private Sub Worksheet_Calculate()
If Range("A1") = 1 Then
Call MyMacro
End If
End Sub

'<<============

This is worksheet event code and should be pasted into the worksheets's code
module (not a standard module and not the workbook's ThisWorkbook module):

*******************************************
Right-click the worksheet's tab

Select 'View Code' from the menu and paste the code.

Alt-F11 to return to Excel.
*******************************************

 

[Norman Jones]

Hi Tom,

I should add, change A1 to your cell of interest.

 

[Tom Jung]

Norman
Works a treat
Many thanks

 

[Guest]

What if I want to start the macro just by changing a letter in the cell, such
as Y or N?