I need to make many Userform Labels and Textboxes.Visible = False
Instead of writing it this way…
Label56.Visible = False
Label57.Visible = False
Label58.Visible = False
I thought this might work but I get a Compile Error: “Sub or Function Not Defined”
What’s missing?
Instead of writing it this way…
Label56.Visible = False
Label57.Visible = False
Label58.Visible = False
I thought this might work but I get a Compile Error: “Sub or Function Not Defined”
What’s missing?
Rich (BB code):
Private Sub OptionButton7_Change()
Dim I as Long
For i = 6 To 46
If OptionButton7 = False Then
Label(i).Visible = False
Next i
End If
‘repeat for TextBoxes
End Sub