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

ActiveSheet.buttons("Button 1").Caption = "New Text"

--
Regards,
Tom Ogilvy


"David" <[email protected]> wrote in message
news:[email protected]...
> 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

Thanks Tom
Much appreciated
--
David

Will this also work for a CommandButton1? I've tried:

ActiveSheet.Buttons("CommandButton1").Caption = "test"
ActiveSheet.CommandButton("CommandButton1").Caption = "test"

It's not working this way. What code should I be using?

Thanks,
Paul


"Tom Ogilvy" <[email protected]> wrote in message
news:%[email protected]...
> ActiveSheet.buttons("Button 1").Caption = "New Text"
>
> --
> Regards,
> Tom Ogilvy
>
>
> "David" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>

Got it!

ActiveSheet.CommandButton1.Caption = "test"

Thanks anyway.

"PCLIVE" <[email protected]> wrote in message
news:[email protected]...
> Will this also work for a CommandButton1? I've tried:
>
> ActiveSheet.Buttons("CommandButton1").Caption = "test"
> ActiveSheet.CommandButton("CommandButton1").Caption = "test"
>
> It's not working this way. What code should I be using?
>
> Thanks,
> Paul
>
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:%[email protected]...
>> ActiveSheet.buttons("Button 1").Caption = "New Text"
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "David" <[email protected]> wrote in message
>> news:[email protected]...
>>> 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
>>
>>
>
>