So, in efforts to solve a different issue in my other users forms I thought it might be easier and fater to try something else. Is it possible to gray out or lock out combo box 2 based on what is selected in Combo box 1?
Basically, if they choose any other country than the US in combobox1 I want the combo box2 locked out so they cant make a selection.
If they choose US on combobox 1 then combo box2 will allow them to pick the next wet of criteria.
Is there a way to do this? Right now this is how I have it, which allows for selections in both boxes to be made regardless of what selection is made in the first combobox1.
Private Sub UserForm_Initialize()
'Fill combobox1
With Me.combobox1
.AddItem "United States"
.AddItem "United Kingdom"
.AddItem "France"
.AddItem "Germany"
.AddItem "Spain"
.AddItem "Italy"
.AddItem "Netherlands"
.AddItem "Canada"
.AddItem "Sweden"
.AddItem "China"
.AddItem "Japan"
.AddItem "Australia"
.AddItem "Switzerland"
.AddItem "Russia"
.AddItem "India"
End With
End If
'fill combobox2
With Me.combobox2
.AddItem "1"
.AddItem "2"
.AddItem "3"
.AddItem "4"
.AddItem "5"
.AddItem "6"
.AddItem "7"
.AddItem "8"
.AddItem "9"
.AddItem "10"
.AddItem "11"
.AddItem "12"
.AddItem "13"
.AddItem "14"
.AddItem "15"
End With
Bookmarks