VBA to Search and Replace??

[riosaaron]

Ive created a in/out time time clock using "Userform"
it works very well, but it's populating my spread sheet row by row. One employee may punch in at 8am and another at 2pm.
I need a code so when the 8am employee punches "OUT", the Out punch data populates in the original row (instead of creating a NEW row)

here is the code i have so far

Please Login or Register  to view this content.

[Leith Ross]

Hello riosaaron,

Welcome to the Forum!

I added a macro to the UserForm that will return the row the person's name is in. If they have not clocked in yet, it returns a zero. If the return value is zero then iRow defaults to the next available row.

Along with this macro, each button now checks if the person has already clocked in or out and displays a message if true. Also a new entry under the same is locked out for 24 hours. here is the macro and the updated UserForm code. All these changes have been made to the attached workbook.

Macro to Return Row Number of Person's Name

Please Login or Register  to view this content.

Updated UserForm Code

Please Login or Register  to view this content.