UserForm Combobox Value based on Worksheet selection (2007)

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

Try this..

Private Sub ComboBox2_Enter()
If Worksheets("Sheet 1").Select Then
    With ComboBox2
        ComboBox2.Clear
        ComboBox2.AddItem "Group 1"
        ComboBox2.AddItem "Group 3"
    End With
elseIf Worksheets("Sheet 2").Select Then
    With ComboBox2
        ComboBox2.Clear
        ComboBox2.AddItem "Group 5"
        ComboBox2.AddItem "Group 6"
    End With
End If
End Sub

This has not been tested...

Tested and it doesn't seem to work it goes back to my Sheet 1 everytime I select another worksheet...

Working Code (From Roy on Ozgrid)

Private Sub ComboBox2_Enter() 
    With Me.combobox2 
        Select Case ActiveSheet.Name 
        Case "Sheet1": .List = Array("Group 1", "Group 3") 
        Case "Sheet2": .List = Array("Group 5", "Group 6") 
        Case "Sheet 3": .List = Array("Group 7") 
        Case "Sheet 4": .List = Array("Group 2", "Group 4") 
        End Select 
    End With 
End Sub