How to step into Worksheet_Change

Piblon · December 16th, 2003, 12:00 PM

I wonder how it is possible to step into
Private Sub Worksheet_Change(ByVal Target As Range)
(This is a built-in Sub within Excel)
As i understand it is not possible because of parameter Target, but I sure want to have the possibility to step into this Sub

Thanks
Piblon

chrislepingwell · December 16th, 2003, 12:18 PM

All you need to do is select the code page for the worksheet in question, select the dropdown at the top left (which should say '(general)'), pick 'Worksheet' then select the 'Change' member of the dropdown on the right. This will give you the Event sub. For a test, write this into it

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

MsgBox Target.Address

End Sub

Got to the actual sheet, type something into a cell, and hit enter. You should get a messagebox showing the affected cell. Then all you need to do is place a breakpoint in the code, and you're done.

Chris

There are two secrets to success in this world:
1. Never tell everything you know

Piblon · December 17th, 2003, 04:11 AM

Thanx