Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a buton "Caption" from VBA
ActiveSheet.Shapes("Name of Button").TextFrame.Characters.Text "Testing 123 -- Ivan F Moal ----------------------------------------------------------------------- Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195 View this thread: http://www.excelforum.com/showthread.php?threadid=27406 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a buton "Caption" from VBA
Assume rather than change the button's name, I assume you mean you want to
change the caption (what is displayed on the button). Activesheet.buttons("ButtonName").Caption = "ABCD" would be another way (perhaps more direct). -- Regards, Tom Ogilvy "0000_AAAA_0000" wrote in message ... 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 Buton from the form Toolbar? -- 0000_AAAA_0000 ------------------------------------------------------------------------ 0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...o&userid=12480 View this thread: http://www.excelforum.com/showthread...hreadid=274065 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
=IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |