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...