Menu
In VBA, how do I access the text value of an ActiveX text box control on an Excel worksheet?
460
Step 1: Click the Text Box button under Insert tab, and insert a textbox in your worksheet. Step 2: While text box is selected put your cursor in the formula bar, type in = symbol and then click on the cell you want to link to, and finally press the Enter key.
You can use ActiveSheet.TextBox1.Text to set or get the contents of an ActiveX textbox control.
If you have more than one ActiveX textbox on a page, you can use ActiveSheet.OLEObjects("boxname").Object.Text to set or get its contents. boxname is the name of the box in quotes ; or with no quotes, a string variable to which you have assigned the name of the textbox; or the object number of the box.
See this Microsoft documentation for more information.
89
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
