ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getting current procedure name (https://www.excelbanter.com/excel-programming/406661-getting-current-procedure-name.html)

x taol

getting current procedure name
 

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...

*** Sent via Developersdex http://www.developersdex.com ***

Gary''s Student

getting current procedure name
 
See:

http://groups.google.com/group/micro...2af99992643b52
--
Gary''s Student - gsnu200770


"x taol" wrote:


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...

*** Sent via Developersdex http://www.developersdex.com ***



All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com