View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamie Martin[_2_] Jamie Martin[_2_] is offline
external usenet poster
 
Posts: 25
Default Macro name as constant

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.