View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default how to get commandbutton name

If you are using command buttons from the control toolbox, just use

Me.CommandButton1.Name

If it is from the Forms toolbar, use

Application.Caller


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sean" wrote in message
...
Hi All,

I have 3 commandbuttons that all run the same piece of code. In the code,

I
want to identify in the peice of code which of the commandbuttons were
clicked to run the code. I just want to get the name, like commandbutton1

or
commandbutton2. Is this possible?
thanks