Name of VBA sub procedure in status bar

[patsfan]

I'm having difficulty trying to find a way for the VBA status bar to reflect the name of the sub procedure.

I have numerous sub procedures and instead of hard coding the Application.Statusbar = "private sub 123()", I would like the status bar to reflect the name of the current sub procedure it is running.

Any suggestions?

 

[John Jairo V]

Hi, patsfan!

There is no way to do it without hard coding. Check this page:
http://www.cpearson.com/excel/InsertProcedureNames.aspx

Blessings!

 

[patsfan]

Thanks John, I appreciate the info.