Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
Worksheet_Change event | Excel Programming | |||
Worksheet_change event. | Excel Programming | |||
Worksheet_change event | Excel Programming | |||
Worksheet_Change Event | Excel Programming |