As suggested, I already sprinkle debugging statements throughout my
coding. In all but the most trivial of procedures I embed something
like this:
If Not gDebug Then On Error GoTo finished
gProcedureName = (whatever) '...Global string variable
Application.Statusbar = gProcedureName
...
finished: if Err.Number > 0 then Wrapup
End Sub '... or Function
Wrapup is a "graceful exit" routine that Ends or Stops according to
the setting of a global constant gDebug (Boolean).
I was hoping that I could use a single generic function call instead
of customizing the definition of gsProcedureName each time. Guess not.
(My typical project uses well over 30 procedures.)
Lisa, thanks also for the tip re MZTools. I'll check it out.
Another question: Anybody know of a good cheap/free VBA code printer?
I've seen a few that run $40-60, but that seems a bit high. Until I
find something better, I'll continue using Notepad++ (which I highly
highly recommend as a substitute for Notepad).