Looping through textboxes

[dave8]

I have a form with some textboxes, e.g., textbox1, textbox2, textbox3, etc. In VBA, I want to put values into these textboxes. How to reference the occurence of each textbox? For example, userform1.textbox1.value, userform1.textbox2.value, and so forth, but I want to do this in a loop because I have 15 or so textboxes to reference.

 

[wigi]

For i = 1 To 15
   Me.Controls("Textbox" & i).Text = ...
Next

FYI, if you use Google searching for your topic title, the 4th website already gives you similar code as above.

http://www.ozgrid.com/VBA/control-loop.htm

 

[dave8]

That was a fast reply. Thank you so much.