Clear contents from Text box via Macro

[ghrek]

HI

I have a workbook that I have got a clear macro on the cells no problem. I also have a text box and want to clear that too automatically. How do I do that via macro?

Thanks

 

[vw412]

I made a worksheet with a Shape Textbox and an ActiveX Textbox and an ActiveX CommandButton to trigger the Textbox changes. Here is code to clear both types of Textboxes:

Private Sub CommandButton1_Click()
  ' Shape Textbox
  Sheets("Sheet1").Shapes("Textbox 1").TextFrame.Characters.Text = ""
  '  ActiveX Textbox
  TextBox1.Text = "New Text"
End Sub