Print Debug Messages

It’s really helpful when developing macros in VBA to get some sort of feedback from the code as to what is going on behind the scenes. Doing this has helped me get rid of superfluous reiterations.

1. Show the Immediate window

immediate_window1

2. Add descriptive messages to the code

add message for immediate window

3. See the debug messages as they are encountered

read immediate window