Worksheet_Change

R

Rasmus

I have the following sub to determine whether another sub should be run:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Range("e" & Target.Row) <> "" Then
MsgBox ("This line qualifies for the sub!")
' Call the sub
End If
End Sub

Is there a way to only run the sub if target is CHANGED from 0 to something
that > 0 ?

Rasmus
 
T

Tom Ogilvy

Only if you store the values of Column E and then compare the appropriate
value to the current value.
 
Top