Stepping through a Macro that acceots parameters

[slash_gnr3k]

Hi all,
I am having trouble with one of my macros and I want to step into it (usually F8) however, as it accepts parameters, it seems I can't do that. It is a worksheet change function:

Please Login or Register  to view this content.

Does anyone know how I can step through this line by line? It would be helpful so that I can see other debugging features held in the locals window etc

Thanks

[:) Sixthsense :)]

Slight correction, It is an worksheet change EVENT which occur if any change happens in that sheet.

Just place the cursor in the next line of the code and press F8 which will add breaking point. Return to that sheet on which the code lies and just press a delete button on any of that sheet cell. Now the event will trigger.

[slash_gnr3k]

Thanks,
It's been driving me mad!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep

[TMS]

Two other options:

1. click in the grey border to the left of the code. You'll get a big red dot which indicates a break point on that line of code.
2. put "Stop" without quotes as the first line of code in the event. The code will stop/break there and you can use F8 to step through from there.

In either case, it doesn't have to be the first line of code, just where you want to trace from. However, it often makes sense to trace from the beginning as the error might have occurred before you think it does.


Regards, TMS

[Kyle123]

@sixthsense, if you want to get really technical, they aren't Events, they are Event handlers - worksheet_change is just a sub that is called when the change Event of the worksheet fires.

[:) Sixthsense :)]

@ Kyle123,

Thanks for the correction I am not an expert in VBA just sharing what I know...

So corrections are always welcome