Macro name as constant

[Jamie Martin]

Can I use a constant in declaring the name of a Sub procedure? Better yet
(so my Sub procedures can continue to have descriptive names), can a
procedure output its own name as a string?

I ask because I have many verbose message boxes that refer to the names of
the macros that a user has invoked or that the invoked macro has called, and
I want to make sure I get the names of the macros right every time.

 

[Bernie Deitrick]

Jamie,

It's easier to just use declared constants:

Sub TestMacro()
Const myName As String = "TestMacro"
MsgBox "The macro " & myName & " has worked.", _
vbOKOnly, "Message from " & myName
End Sub

HTH,
Bernie

 

[Chip Pearson]

Jamie,

Unfortunately, there is no way to get programmatically the name of the
currently executing procedure. You can, of course, hard code the name of the
procedure within each macro, and some 3-party tools can automate this (e.g.,
MZ-Tools), but in the end, the name is hard coded.

 

[Jamie Martin]

Yeah, that's a good trick. Much easier to maintain. Thanks.