Name of module

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

If i am on a sub, function, or module

Is there a way i can print the name of the sub, function and the module i'm
am right now?
 
Hi Roy,

As far as I know VBA doesn't expose this information. You'll need to
provide it yourself, e.g. by including a constant declaration in every
module and procedure:

Const MODULE_NAME = "vbWidgetCode"
....
Const PROC_NAME = "CountWidgets"
 

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

running a Sub in a class module from a functionin a general module 2
My Selected print in the list box does not work 4
Module 2
Refering to Form controls in a general module 3
Record UserID in form 8
Retyping reference to formfield in module 10
Outlook Private Sub Application_Startup()....What if it be public 1
Outlook autorun module 0

Back
Top