PDA

View Full Version : Solved: Get Textbox Value



mferrisi
08-02-2012, 11:18 AM
I'm trying to pull in the values for many textboxes, made from Developer->Insert-> ActiveXControl.

I can get the value if I do Worksheets(1).TextBox3.Text, but I have 50 textboxes. I want to be able to loop through and reference each one, like


i = Worksheets(1).Shapes("Textbox" & x).text

Or something similar.

Thank you for your help.

Bob Phillips
08-02-2012, 01:07 PM
i = Worksheets(1).OLEObjects("TextBox" & x).Object.Text

mferrisi
08-03-2012, 04:33 AM
Thank you!