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.
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.