Worksheet_Change event
Private Sub Worksheet_Change(ByVal Target As Range)
Call sandy
End Sub
and in a standard module:
Sub sandy()
MsgBox ("hi")
End Sub
If sandy needs Target, have the Event code save Target in a public variable
and then modify sandy to use the public variable.
--
Gary''s Student - gsnu200735
"Sandy" wrote:
How can I go through a "Worksheet_Change" event manually to check the code
is working as intended?
I believe inserting a breakpoint after 1st line is a start but I don't know
how to do that!
Step by step would be good!
Sandy
|