View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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