Good day,
having trouble with the following here:
Private Sub ComboBox2_Enter()
If Worksheets("Sheet 1").Select Then
With ComboBox2
ComboBox2.Clear
ComboBox2.AddItem "Group 1"
ComboBox2.AddItem "Group 3"
End With
End If
If Worksheets("Sheet 2").Select Then
With ComboBox2
ComboBox2.Clear
ComboBox2.AddItem "Group 5"
ComboBox2.AddItem "Group 6"
End With
End If
End Sub
What I am trying to do is if I am in Sheet 1 then populate the userform combobox2 with, example "Group 1" and "Group 3"
If I am in Sheet 2 then populate my Combobox with "Group 5" and "Group 6"
That code is bringing me to the worksheet itself... what should I change the ".Select" to...
Bookmarks