ExcelBanter

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

tom taol

getting current procedure name
 


sub aaa()
~~~~~
msgbox currentProcedureName
end sub

thus, i want to show aaa in messagebox.

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

JMB

getting current procedure name
 
The only way I know how to do that is

sub aaa()
Const strProcedure As String = "aaa"
......
msgbox strProcedure
End Sub



"tom taol" wrote:



sub aaa()
~~~~~
msgbox currentProcedureName
end sub

thus, i want to show aaa in messagebox.

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



All times are GMT +1. The time now is 07:31 AM.

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