that's cool. is there any way to have the macro pull out the name
automatically without hard coding it?
just wondering.
:)
susan


On May 29, 2:15*pm, FSt1 wrote:
hi
you can use the status bar.
when writing the sub, you know the name of the sub your are writing.
at the beginning of the sub add this like
application.statusbar = "sub now running = mysub"
at the end of the sub ad this line
application.statusbar = False

the name of the sub will appear in the lower left on the status bar.

Regards
FSt1



"FunkySquid" wrote:
Is there anyway of displaying the current sub or function name that is
running?

Something like:

Sub DisplaySubName()
* MsgBox ThisSub.Name
End Sub- Hide quoted text -

- Show quoted text -