Thread: after click a button(commandbutton), getting the button name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
  
Posts: 586
Default after click a button(commandbutton), getting the button name
You just need to use the caption property of the command button.

MsgBox "this button name is " & btn.Caption

"x taol" wrote:


Dim btn As MSForms.CommandButton

A sheet has a commandbutton.
what i want to, I click the button, getting the button name.
msgbox "this button name is " & xxx






*** Sent via Developersdex http://www.developersdex.com ***

Reply With QuoteReply With Quote