hi im trying to create an attendence sheet where once the user tick in the check box it will display the time and save time to know what time the user sign in.i did use the Ctrl + Shift + ; but i dont think that is appropriate because i dont want the user to enter it manually. i did use the format NOW() too but it keeps on changing according to the time.please i need help.
Try the link to insert the time. The user can double click the cell to add the time
http://www.excelforum.com/showthread.php?t=620842
For a log of the time it was open use an event macro. Code goes in ThisWorkbook module
http://www.mvps.org/dmcritchie/excel/getstarted.htm
VBA Noob
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks