Run macro IF

[willemeulen]

How do I run a macro IF ....


Cell T67 is TRUE, and repeat when data is updated?

:help

[garydp]

you can try


Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("T67")) Is Nothing Then
Exit Sub
Else
'Your Macro Name Here
End If
End Sub

[p45cal]

you can try


Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("T67")) Is Nothing Then
Exit Sub
Else
'Your Macro Name Here
End If
End Sub

If I'm not mistaken, doesn't that miss out testing for true?
Perhaps this?
Private Sub Worksheet_Change(ByVal Target As Range)
If Not (Intersect(Target, Range("T67")) Is Nothing) And Range("T67") = True Then YourMacroName
End Sub

[willemeulen]

will try on monday. And second post was right. But in my case I want to check the true statement first, if not true exit otherwise run macro.

When other cell changes run macro again.

The cell containing true actually checks if all data needed for the required calculation is completed by user, if not it will show false.
The second cell i will do a summ of all input data, when this sum changes the macro has to run agian.

t

[D_Rennie]

hello

you will need to use the aftercalculation event