clear a textbox with vba - getting 424 object required error

Question

i am trying to clear a textbox called "text box 2"

i have tried the following:

TextBox2.Value = ""

^ gets a 424 object required error

TextBox2.Text = ""

^ gets a 424 object required error

Worksheets("Proposal").Textbox2.Value = ""

^ gets a runtime error 438, object doesnt support this property or method

Worksheets("Proposal").Textbox2.Text = ""

^ gets a runtime error 438, object doesnt support this property or method

Answer 1

Since it is a form control:

Worksheets("Proposal").Shapes("Text Box 2").Value = ""

And since you changed it to an ActiveX control:

Worksheets("Proposal").TextBox2.Value = "" 'This assumes that your newly created text box is still "TextBox2"