Time Out and Time in

[markusvirus]

Hi Experts,

Can someone help me write a code for my file. I'm trying to monitor the people who goes out by noting the time they go out, and the time they get back in. I have a file that has a userform where if they put the Emp Code, the Emp Name should show. I either select "In" or "Out" button and transfer the data to the "InOut" sheet. Please see the file attached and the userform in it. Many Thanks!

[sintek]

Hi markusvirus

This code to be placed within the [IN] button

Please Login or Register  to view this content.

This code for [OPEN FORM]

Please Login or Register  to view this content.

This code for ComboBox1...PS I changed your combobox2 to a textbox as the choice of empl no automatically inserts the name into Textbox

Please Login or Register  to view this content.

This code goes into [OUT] button

Please Login or Register  to view this content.

[markusvirus]

hi sintek, thank you so much. I just can't see the attachment

[sintek]

Here's an example workbook with the inner workings

[markusvirus]

Hi Sintek,

The form looks great! It's just that what I intend to get is in reverse. The employee would go out first, and when they get back, the duration that they were out will be computed. and I was also wondering why there are 2 clock outs? Thank you so much for helping me out.

[sintek]

Oops the last [Clock Out] button must be renamed [Exit]...This closes or hides the userform.
have a look now and see if it is right..

[markusvirus]

Hi sintek,

This worked perfectly. Thank you!!

[sintek]

Glad to have helped. Thanks for rep points. Please mark thread as solved.