UserForm Combobox Value based on Worksheet selection (2007)

Good day,
having trouble with the following here:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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)

Please Login or Register  to view this content.