Solved: Help needed with sign in register

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

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

Quote:

---

Originally Posted by ALe

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

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

Quote:

---

Originally Posted by ALe

[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

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

ignore :)