| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get the name of the currently active procedure?
Is there a way to programatically get the name of the currently active
procedure? (sub or function, and the module in which it resides) thanks, Harry |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get the name of the currently active procedure?
Lots of people use a global variable and change that variable to the procedure
that they're in at the top of the module (when they enter the procedure). I guess that MZTools has a routine that does this for you. http://www.mztools.com/index.aspx But there's nothing built into excel to do it for you. Harry wrote: Is there a way to programatically get the name of the currently active procedure? (sub or function, and the module in which it resides) thanks, Harry -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to jump from a Form procedure to a Workbook or Module procedure? | Excel Programming | |||
| Obtaining Active Document Name from WORD for Excel procedure | Excel Programming | |||
| Function Sub Procedure If Not Active Worksheet | Excel Programming | |||
| Unable to set the active cell from within a VBA procedure | Excel Programming | |||
Hybrid Mode
