Thread: Change a buton "Caption" from VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
0000_AAAA_0000[_5_] 0000_AAAA_0000[_5_] is offline
external usenet poster
  
Posts: 1
Default Change a buton "Caption" from VBA

Hi!

and Many Thanks in Advance!


If i have a commandBoton; to change his caption
all I have to do is:

Sub AAA()
With ActiveSheet.CommandButton1
.Caption = "NewName"
End With
End Sub



but:

how can I change a Button name when is not a CommandBoton but a Buto
from the form Toolbar

--
0000_AAAA_000
-----------------------------------------------------------------------
0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...fo&userid=1248
View this thread: http://www.excelforum.com/showthread.php?threadid=27406

Reply With QuoteReply With Quote