Thanks, Chip, for your response. By the way, I used your routines for saving
variables to the user registry. Very, very cool. Works great!

Stu W

"Chip Pearson" wrote:

Stu,

There is no built in way for a procedure to get its own name. I have code on
my web site that will insert a const declaration in to every procedure. The
value of the const is the name of the procedure in which it resides. See
www.cpearson.com/excel/InsertProcedureNames.aspx . You can then use that
const value in your MsgBox.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Stu W" wrote in message
...
Is there a way to refer to the currently running module and procedure name
in
a msgbox?