Variable Name for TextBox

[Summitman]

Need to assign a variable name to a TextBox or CheckBox.
A form with 30 TextBoxes (txtFirstName1, txtFirstName2,... txtLastName1, etc.) requires a line of code to get values, set values, set formats etc. for each TextBox. By having a variable name like FirstName(1), FirstName(2), etc. a For/Next or other loop could be used to simplify the code. VBA won't allow parenthesis in the assigned TextBox name.
Are there other options to handle the code for 30 TextBoxes other than individually?
Thanks,
JWoller

 

[Ruddles]

You can loop through them if that's any help:-

  For i = 1 To 30
    Controls.Item("txtFirstName" & i) = "This is txtFirstName" & i
  Next i

 

[Summitman]

Thanks Ruddles. I'll give it a try.

 

[Summitman]

Ruddles, it worked like a CHAMP!!
Thank you very much.
It condensed my code considerably and I appreciate your help.

Summitman