LinkBack URL
About LinkBacks
Hello,
I have been using excel for various things and am well versed in formulas. However, I am fairly new to macros/VBA and need some help. I have watched numerous tutorial videos and have read up on the basics but I cant seem to figure this out.
I am trying to create a Spreadsheet to enter and keep track of employee hours. My idea is, in sheet1, I would like to have a clickable list of employees. I would also like to have two buttons, one for clock in, and one for clock out. The employee would click on their name then click on the corresponding button (depending on if they are clocking in or out). On sheet2, it will have a list of employees and their times. So lets say the employee clicks "clock in", i would like it to insert their name and a current date and time stamp in sheet2, columns A+B, row 1. The next employee would get entered into row 2, and so on and so forth. Then when they clock out, it would recognize the name and insert the stamp in the corresponding row but in the column one to the right of their first stamp. The next day, it will make a whole new entry for the employee in the next available row down. I do not know how to work the code for the buttons, or how to do the clickable list of employees. Any help would be much appreciated. Thank you.
Register To Reply
Bookmarks