VBA property for Sub procedure name

G

Guest

Is there a property that will identify the name of the VBA Sub procedure that
is running? I have a sub that runs for about 5 minutes, with no visible
changes to the screen. This sub calls 12 other subs, one after the other. I
want to display the name of whichever 1 of the 12 subs is running, so I know
where I am during the 5 minutes. I know I could hardcode the names into each
of the 12 subs, but I'm just trying be a little more elegant about it.

Thanks,
Charlie Rowe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming Of Sub Procedures 6
Which Excel event to call when opening a .txt file 1
Can I use a variable contain the name of a sub or function to call it? 4
Using a Calculated Value from a Custom Function in the Calling Sub 4
disappearing procedure 2
Excel VBA help: Text file formatting 19
VBA CreateNames (ignores last 5 rows?) 6
Macro to Call A Subroutine on a Sheet Sometimes stops? 1

Top