| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to apply button text from macro?
Greetings and TIA for your time
Button1 triggers Macro1. Macro1 has code to change the text on Button1 Using a button from the 'forms' toolbar I've tried:ActiveSheet.Shapes("Button 1").Characters.Text = "NewText" - which fails. What code should I use? David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to apply button text from macro?
ActiveSheet.buttons("Button 1").Caption = "New Text"
-- Regards, Tom Ogilvy "David" wrote in message ... Greetings and TIA for your time Button1 triggers Macro1. Macro1 has code to change the text on Button1 Using a button from the 'forms' toolbar I've tried:ActiveSheet.Shapes("Button 1").Characters.Text = "NewText" - which fails. What code should I use? David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to apply button text from macro?
Thanks Tom
Much appreciated -- David |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to apply button text from macro?
Will this also work for a CommandButton1? I've tried:
ActiveSheet.Buttons("CommandButton1").Caption = "test" ActiveSheet.CommandButton("CommandButton1").Captio n = "test" It's not working this way. What code should I be using? Thanks, Paul "Tom Ogilvy" wrote in message ... ActiveSheet.buttons("Button 1").Caption = "New Text" -- Regards, Tom Ogilvy "David" wrote in message ... Greetings and TIA for your time Button1 triggers Macro1. Macro1 has code to change the text on Button1 Using a button from the 'forms' toolbar I've tried:ActiveSheet.Shapes("Button 1").Characters.Text = "NewText" - which fails. What code should I use? David |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to apply button text from macro?
Got it!
ActiveSheet.CommandButton1.Caption = "test" Thanks anyway. "PCLIVE" wrote in message ... Will this also work for a CommandButton1? I've tried: ActiveSheet.Buttons("CommandButton1").Caption = "test" ActiveSheet.CommandButton("CommandButton1").Captio n = "test" It's not working this way. What code should I be using? Thanks, Paul "Tom Ogilvy" wrote in message ... ActiveSheet.buttons("Button 1").Caption = "New Text" -- Regards, Tom Ogilvy "David" wrote in message ... Greetings and TIA for your time Button1 triggers Macro1. Macro1 has code to change the text on Button1 Using a button from the 'forms' toolbar I've tried:ActiveSheet.Shapes("Button 1").Characters.Text = "NewText" - which fails. What code should I use? David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro apply to all worksheet | Excel Worksheet Functions | |||
| Random text via Macro button | Excel Discussion (Misc queries) | |||
| Apply macro to one sheet only | Excel Discussion (Misc queries) | |||
| Apply a Macro to a FunctionKey... | Excel Programming | |||
| Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
Linear Mode
