getting current procedure name

  • Thread starter Thread starter x taol
  • Start date Start date
X

x taol

sub test()
msgbox thisProcName
end sub

the result message 'test'

i want to make that thisProcName routine.

It must run though vbe window is closed.this is keypoint.
thus, it's not using activecodepane property...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controlling execution of a Sub Procedure 1
getting current procedure name 1
Check Workbook name currently opens is correctly 4
Calling subroutine defined in another workbook (autostart workbook) 5
Change event code Find .Activate does not activate Target.value 4
Trying to run excel vba code when cell value changes from empty to entered value. 1
Assigning a constant to a range name 8
Excel process still shows in TaskManager 7

Back
Top