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

Is this an ActiveX text box? Is it directly on your worksheet? — Kyle
– Kyle, Commented Jul 7, 2016 at 17:12
how can i verify i am working with an activex textbox? @Kyle — alilland
– alilland, Commented Jul 7, 2016 at 17:13
ActiveSheet.OLEObjects("text box 2").Object.Value = ""? Also, is it called "text box 2", or is it TextBox2? — BruceWayne
– BruceWayne, Commented Jul 7, 2016 at 17:16
Please post the rest of your (relevant) code. Also, can you clarify if the text box is named "text box 2" or if you want to access TextBox2? Right now, as you can see, we're just making some guesses.... — BruceWayne
– BruceWayne, Commented Jul 7, 2016 at 17:19

Kyle · Accepted Answer · 2016-07-07 17:49:15Z

2

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"

answered Jul 7, 2016 at 17:26

Kyle

2,5452 gold badges19 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Benno Grimm · Accepted Answer · 2016-07-07 17:28:51Z

0

Change to ActiveX and use

Proposal.TextBox2.Text = ""

answered Jul 7, 2016 at 17:28

Benno Grimm

5401 gold badge9 silver badges16 bronze badges