PDA

View Full Version : Solved: Help needed with sign in register



Paul C
07-04-2006, 01:54 AM
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
07-04-2006, 02:35 AM
Just an idea. I had problem with the today function but it works.

Paul C
07-04-2006, 05:22 AM
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
07-04-2006, 05:54 AM
Private Sub CommandButton3_Click()
Cells((ActiveCell.Row), 13).Value = Hour(Now) & ":" & Minute(Now)
End Sub

Paul C
07-04-2006, 06:32 AM
Private Sub CommandButton3_Click()
Cells((ActiveCell.Row), 13).Value = Hour(Now) & ":" & Minute(Now)
End Sub

Thanks a lot ALe its much appreciated

Best Regards

Paul

ALe
07-04-2006, 07:25 AM
Paul, don't forget to mark this thread as solved

Paul C
07-04-2006, 12:04 PM
ignore :)