Geek asks and answers

ActiveX text box text on Excel worksheet

In VBA, how do I access the text value of an ActiveX text box control in an Excel worksheet?

Thank.

+5
source share
1 answer

You can use ActiveSheet.TextBox1.Textto install or retrieve the contents of an ActiveX text box control.

If a page has more than one ActiveX text field, you can use ActiveSheet.OLEObjects("boxname").Object.Textto set or retrieve its contents. boxname is the name of the field in quotation marks; or without quotation marks, the string variable to which you have assigned the name of the text field; or object number in the field.

See the Microsoft documentation for more details .

+11
source

More articles:


All Articles