Thread: referring to the button that triggered the macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default referring to the button that triggered the macro
Callername = Right(Parent.Parent.Caller, 3)
MsgBox Callername

" wrote:

Hello,
In one of my subs I need to capture the name of the button that
triggered it. Something like
right(thisbutton.name,3).
Could anyone tell me how to do this?
Thanks a lot.
Herman

Reply With QuoteReply With Quote