View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default FUNCTION TO CALL NAME OF SELF (BUTTON)

There are buttons, buttons, buttons and other buttons. But if you're able to
assign macros to them then
Application.Caller
is often pretty useful.

HTH. Best wishes Harald

"Wandering Mage" skrev i melding
...
What I am trying to find, is a function in a macro that
will call the name of itself. I will attach the macro to
the button and want it to get the name of the button that
fired it. Can anyone help me on how to do that?! Really
need to know, thank you!