Get Macro Name (while it's running).

[CEC]

Hi everyone,

I've implemented an error system in my program (using VBA in Excel). I would like know if there's an easy way to capture the name of a running macro.

Given that this is an error handleling system, I'd rather use excel coding to get the macro name rather than manually putting the name every time i launch a routine/function as this might lead to other errors due to typos, routine changes, etc.

The closest I've come across is this code:

Please Login or Register  to view this content.

Any thoughts on how I could get the name of the macro ???

Any help is apprecited.

[CEC]

Update:

I figured a workaround but it's not pretty.

The following would give me the Object name (userform, module, class) but I still haven't figured how to grap the procedure name...

Object capture

Please Login or Register  to view this content.

At the moment, I'm using 3 public variables in a module (AppRegistry). I'm stuck with the following code (inserted in every procedure for the program)...I need to replace (in this example) --> AppRegistry.ActiveProcess = "Att_Retrieve_Click()" for something more dynamic. See example below:

Please Login or Register  to view this content.

Hope this can help you help me...I'm desperate (it's been a day and I still haven't figured it out!).

Thanks.

[CEC]

Nevermind, this isn't working while it's running. It appears the VBA engine simply will not recognize the module or its running macro while it's running. Although you might see the value displayed when entering debug mode, the values will not be "defined" while it's running.

The following example will not be defined while it's running but will display a value in debug:

i.e.

Please Login or Register  to view this content.

I'm giving up this project. I'll simply hardcode everything though a public variable that'll switch everytime I open/close a userform or call/run routines/functions. It's sloppy and not the way I would have done it but it looks like it's the only way.

Feel free to prove me wrong...

Regards,

Alex