Good day,
Trying to figure our how to do the following:
Userform:
Private Sub ComboBox2_Change()
ComboBox3.Clear
Select Case ComboBox2.ListIndex
Case 1
arrData = list1
Case 2
arrData = list2
Case 3
arrData = list3
Case Else
Exit Sub
End Select
ComboBox3.List = arrData
End Sub
My list is based on a control sheet that I have but I need that if Combobox 2 = Case 0 then to make my Combobox3.Enable = False and if not Case 0 then Combobox3.Enable = True.
Is this possible or I would need a (Combobox2_Change) If / Else /End If function?
Bookmarks