for Looping in VBA/Form
"Toppers" wrote:
For i = 1 To 3
Controls("Pax" & i).Caption = Range("d" & i+4)
Next i
For i = 31 To 33
Controls("Textbox" & i).Visible = False
Next i
HTH
"Excel 2003 - SPB" wrote:
I have many areas of code that could be cleaned if I only knew how
I think it would be a "For" statement in both cases
example 1
Pax1.Caption = Range("d5")
Pax2.Caption = Range("d6")
Pax3.Caption = Range("d7")
etc
example 2
TextBox31.Visible = False
TextBox32.Visible = False
TextBox33.Visible = False
I tried this
For i = 1 To 6
Seat " & i &.Caption = Range(""a" & i + l2 & """)"
next i
with no luck, I get a compile error highlighting "Seat"
Many thanks for any help
Great! I knew it would be simple
Thanks to both of you
|