How to know which macro is running

[ilya2004]

I have a spreadsheet that uses several activex box to feed values into linked cells as well as trigger a few different events around the sheet.

Some of these activex box are set to run macros on change and sometimes a different macro will write into the cells that are linked to these boxes and this will set off their macro as well.

Bottom line:

I now have a whole bunch of macros going off even when I don't intend it. I want know if there is a way to have excel tell me as it is running which macros are being run.

This could be either as after the fact or as message boxes while they are running.

What is the vba code for "name of current macro" so that I could maybe add something to the code like

msgbox current_macro.name.

 

[Andrew Poulsom]

You would need to pass the name to the MsgBox explicitly.

 

[Warship]

Welcome to the board.

If you are using msgbox in each macro, just hardcode the macro name.

Or you could set up Public variables like:

Public MacroAisRunning as boolean
Public MacroBisRunning as boolean

Then trigger MacroAisRunning True/False as you enter and exit the macros.

 

[ilya2004]

Hi, thank you for your help so far.

So is there no code which allows the macro to refer its own name?

It would be a lot easier to just paste one line of code to display the name of the currently running macro, rather than going through one by one to each macro and writing out it's name.

i.e.

doing msgbox currentmacro name

instead of
msgbox "macro1"
msgbox "macro2" etc...

 

[ilya2004]

Alternatively if you have another idea how I can solve my issue, I would thrilled to hear it. (Though I would still like to know how to have a macro refer to itself)