FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,362
- Office Version
- 365
- 2016
- Platform
- Windows
I have four option buttons on my user form and need to enable/disable some text boxes based on which option is selected. The code below works fine, but before I code the same for the other there option buttons, can this be reconstructed into the loop thru?
Code:
Private Sub Opt1_Click()
If Me.Opt1 Then
Me.txtQtr1.Enabled = True
Me.txtQtr1e.Enabled = True
Me.txtQtr1n.Enabled = True
Me.txtQtr2.Enabled = False
Me.txtQtr2e.Enabled = False
Me.txtQtr2n.Enabled = False
Me.txtQtr3.Enabled = False
Me.txtQtr3e.Enabled = False
Me.txtQtr3n.Enabled = False
Me.txtQtr4.Enabled = False
Me.txtQtr4e.Enabled = False
Me.txtQtr4n.Enabled = False
End If
End Sub