VBA Employee Time Punch

[chinguyen]

Hi all,

I am trying to develop a time punch userform where my people only need to click the buttons to log in and out. And I want to track it daily.

My work is in progress. Please see attached 3 sheets. And now I am so stuck.

https://drive.google.com/file/d/1Y_gkdrNJmGrOQnMzGITDpKF01Z5sqcJH/view?usp=sharing

Can anyone help me with this? I don't know how to assign a macro to the 2 command buttons, and I have trouble saving these inputs in the Summary sheet.

I would really appreciate your help. Thank you so very much!!

 

[mole999]

if you have the button, right click on it and edit macro and then navigate

 

[dmt32]

Hi,
always worth a look to see what others have done when starting a project like this

here is one I found:https://gallery.technet.microsoft.com/office/Excel-Employee-Punch-Clock-5374123e

you can download sample workbook for free and may give you some pointers in developing your own project.

Dave