Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Gwen Fields   on Dec 30 In MS Office Category.

  
Question Answered By: Abbas Hashmi   on Dec 30

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).

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Identifying which procedure is running Or get search suggestion and latest updates.


Tagged: