Hi! First of all let me tell u how much this forum have help me!! it's awesome!!
But right now i'm having a problem with this code:
Private Sub UserForm_Initialize()
Dim i, b As Integer
For b = 10 To 18
If Controls("CheckBox" & b).Value = True Then
For i = 1 To 9
Controls("ComboBox" & i).ListIndex = -1
Controls("ComboBox" & i).Enabled = False
Controls("CheckBox" & i).Enabled = False
Controls("CheckBox" & i).Value = False
Next
Else
For i = 1 To 9
Controls("ComboBox" & i).Enabled = True
Next
End If
Next
End Sub
I think u get what's the general idea, but it seems i can´t get the code to work.
Please help!
But right now i'm having a problem with this code:
Private Sub UserForm_Initialize()
Dim i, b As Integer
For b = 10 To 18
If Controls("CheckBox" & b).Value = True Then
For i = 1 To 9
Controls("ComboBox" & i).ListIndex = -1
Controls("ComboBox" & i).Enabled = False
Controls("CheckBox" & i).Enabled = False
Controls("CheckBox" & i).Value = False
Next
Else
For i = 1 To 9
Controls("ComboBox" & i).Enabled = True
Next
End If
Next
End Sub
I think u get what's the general idea, but it seems i can´t get the code to work.
Please help!