Solved: Help needed with sign in register

[Paul C]

Hi I am designing a sign in register for work, i need to have a button which will input the current time into the register when pushed, I also need a date button, the idea being when someone signs in they input there name, then simple press the time-in button and date button, any ideas on how this can be done?


I have attached a sign in register fto give you a idea, but need the time in , time out and date buttons added.

Thanks for any help, its very much appreciated.

Paul

[ALe]

Just an idea. I had problem with the today function but it works.

[Paul C]

Just an idea. I had problem with the today function but it works.

Hi ALe, Thankyou for replying, it works great but i need the time out button to put the time out in the specific row i highlight, anyone know of a way of doing this.?

Sorry to be such a pain.


Paul

[ALe]

[VBA]Private Sub CommandButton3_Click()
Cells((ActiveCell.Row), 13).Value = Hour(Now) & ":" & Minute(Now)
End Sub[/VBA]

[Paul C]

[vba]Private Sub CommandButton3_Click()
Cells((ActiveCell.Row), 13).Value = Hour(Now) & ":" & Minute(Now)
End Sub[/vba]

Thanks a lot ALe its much appreciated

Best Regards

Paul

[ALe]

Paul, don't forget to mark this thread as solved

[Paul C]

ignore