control worksheet with combobox value

Hello guys,
Please I am lost. I have searched the forum to see if I can find a previous thread but could not.
My problem: Iam trying to develope a time sheet to enable us clock in/out from a computer. I have a user form that holds a combo box and the combobox is populated with my staff names. What I want is when a staff selects his name from the combobox, it shoud activate a worksheet with the staff's name. this worksheet becomes the active worksheet to capture the staff time inputs. I have bellow the codes I am using.
Please help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I suggest you read the Fotum Rules & use the Edit button to add Code Tags before you run out of time for editing your post.

It looks like you setting the variable es but not then using the With statement

Please Login or Register  to view this content.

See if this works

Please Login or Register  to view this content.