| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change CommandButton Caption
Hi
Does anyone know how to change the text on a command button? The following does not work: ActiveSheet.Shapes("CommandButton1").Caption = "test" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change CommandButton Caption
Claude,
Try the following: ActiveSheet.Buttons("Button 1").Caption = "test" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Claude" wrote in message ... Hi Does anyone know how to change the text on a command button? The following does not work: ActiveSheet.Shapes("CommandButton1").Caption = "test" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change CommandButton Caption
ActiveSheet.OleObjects.("CommandButton1").Object.C aption = "test"
-- Regards, Tom Ogilvy "Claude" wrote in message ... Hi Does anyone know how to change the text on a command button? The following does not work: ActiveSheet.Shapes("CommandButton1").Caption = "test" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change CommandButton Caption
"Claude" wrote in message ...
Hi Does anyone know how to change the text on a command button? The following does not work: ActiveSheet.Shapes("CommandButton1").Caption = "test" Try this: ActiveSheet.CommandButton1.Caption = "test" |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change CommandButton Caption
Hi Lisa
This one worked! Thanks -----Original Message----- "Claude" wrote in message ... Hi Does anyone know how to change the text on a command button? The following does not work: ActiveSheet.Shapes("CommandButton1").Caption = "test" Try this: ActiveSheet.CommandButton1.Caption = "test" . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change caption of a button | Excel Worksheet Functions | |||
| Change caption on a macro button | Excel Worksheet Functions | |||
| The font of the caption for the commandbutton is illegible. | Excel Discussion (Misc queries) | |||
| VBA to change excel caption picture | Excel Programming | |||
| CommandButton.Caption | Excel Programming | |||
Linear Mode
