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"
 
Back
Top