FlintBeastwood
Technical User
I would like to select control items in a For loop. For example:
For i=1 to 10
If ThisWorkbook.Worksheets("sheet1"
.Cells(6, i)= "" Then
TextBox(i).Enabled = False
next i
Of course the TextBox(i) call is wrong, how can I select the controls in a loop so I do not have to call them all individually (is there a numbered property)?
For i=1 to 10
If ThisWorkbook.Worksheets("sheet1"
TextBox(i).Enabled = False
next i
Of course the TextBox(i) call is wrong, how can I select the controls in a loop so I do not have to call them all individually (is there a numbered property)?