Help with Punch Clock

So I think I got it all lined up - all I need now is someone who's willing to help me make the buttons actually work :D

Is it possible to get PUNCK IN and PUNCH OUT - to timestamp in the correct fields in DATA-sheet?
Scenario: Employee inserts his idnumber - punch in!
->vica versa

Would be genious if a popup could tell them they punched in/out!

Can the data/employee-sheets be prompted with a password before hidden/unhidden?

It's vital the workbook autosaves everytime someone either punches in or out!

WorkTime.xlsx

Check out the attached workbook and see if its something you might can use. When clocking In an Out, code uses today date. Code looks to see If Employee has a clock in time, if not add new record to the Table.


When you click on the Time Clock button In the worksheet, a user form pops up. Select and Employee Name from the ComboButton.
Then enter in the "CORRECT" ID for employee selected in the ComboBox. Then click the Clock In/Clock-Out button. If ID is not correct there will be a message saying ID is not correct.

Also checks if employee has already Clocked in and out for Todays Date.

Didn't add any comments to code, in case this wasn't something you could use.

Check out the attached workbook and see if its something you might can use. When clocking In an Out, code uses today date. Code looks to see If Employee has a clock in time, if not add new record to the Table.


When you click on the Time Clock button In the worksheet, a user form pops up. Select and Employee Name from the ComboButton.
Then enter in the "CORRECT" ID for employee selected in the ComboBox. Then click the Clock In/Clock-Out button. If ID is not correct there will be a message saying ID is not correct.

Also checks if employee has already Clocked in and out for Todays Date.

Didn't add any comments to code, in case this wasn't something you could use.

Originally Posted by mike7952

Check out the attached workbook and see if its something you might can use. When clocking In an Out, code uses today date. Code looks to see If Employee has a clock in time, if not add new record to the Table.


When you click on the Time Clock button In the worksheet, a user form pops up. Select and Employee Name from the ComboButton.
Then enter in the "CORRECT" ID for employee selected in the ComboBox. Then click the Clock In/Clock-Out button. If ID is not correct there will be a message saying ID is not correct.

Also checks if employee has already Clocked in and out for Todays Date.

Didn't add any comments to code, in case this wasn't something you could use.

Wauw, sorry for not replyn' until now sir. This comes really really close to perfect. Is there a way in data I could do a =SUM for each employee, and then 2 boxes "FROM" and "TILL" boxes, so that when having to do salary, I could enter last time I did it, and get a now total on Person X -> Person Y

Time-Clock V2.xlsm