Change Text in Text Box

[nigelk]

Hi all,

I've got a text box on a sheet (linked to a macro) and I need to change the wording when it's pressed

I've tried

ActiveSheet.Shapes.("TEXTBOX 4").Text = "Stopped"

and

ActiveSheet.Textbox.("TEXTBOX 4").Text = "Stopped"

but neither work.

Can you help?

Thanks,Nigel

 

[mikerickson]

Try it without the dots before the left parenthesis.

 

[nigelk]

No, that won't work either.

Nigel.

 

[mikerickson]

What kind of text box is it? ActiveX or otherwise. perhaps

ActiveSheet.Shapes("TextBox 4").TextFrame.Characters.Text = "stopped"

 

[nigelk]

Thanks, that worked!.

Nigel.