Debug on Worksheet_change event

**sandu1** · 11-02-2016, 01:25 PM

Hi,

I am starter in VBA. Please suggest how do i debug worksheet_change events.

In VBA, debugging modules is straight foward using F8. But when I press F8 on changevents nothing happens. Whats the best way to see the flow from worksheet_change events to other modules?

Thanks in Advance

**gmr4evr1** · 11-02-2016, 01:39 PM

That is a good question that I would also like the answer to. Here is what I do in that situation..
Remove a letter from a line at the beginning of your code
Do something on the worksheet to trigger the Change event. This will cause the code to error out on the line you removed the letter from.
Correct the line, then you can F8 through the rest of the lines.

**MrShorty** · 11-02-2016, 01:49 PM

Stop statement: https://msdn.microsoft.com/en-us/lib.../gg264373.aspx Putting a Stop statement where you want the code to stop and enter debug mode allows you to call the event procedure by triggering the event, and enter debug mode. I often put a Stop statement right at the beginning of such a procedure so I can see what data got passed to the procedure. When your procedure is all debugged, then you can clear or comment out all the stop statements.