Hello Zac,

You almost have it. Not bad for newbie.
________________________________________________________________

Dim MaxTB As Long
Dim I As Long
Dim TB As Object


MaxTB = Range("A1").Value

For I = MaxTB + 1 To 40

' Set Object Variable TB to point to TextBox'n' on the user form
Set TB = UserForm1.Controls("TextBox" & Trim(Str(I)))

' Set the TextBox Visible property to False - Hide it!
TB.Visible = False

Next I
________________________________________________________________

Hope this helps,
Leith Ross