Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula For CTRL+SHIFT+;
We are looking for a way to program a cell(s) to post the current time when a
certain action is done. The idea is like a time clock for our employees to record start times and ending times. It will then be used by other worksheets within the workbook to record employee payroll and other information for our business. ( ex. one keystoke to record current time) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula For CTRL+SHIFT+;
Sub InsertTime() With ActiveCell .NumberFormat = "hh:mm:ss" .Value2 = Time End With End Sub more logical would be to avoid dependency on activecell and make it ready to be called as a subroutine.. Sub InsertTime2(rng as range) With rng.cells(1) .NumberFormat = "hh:mm:ss" .Value2 = Time End With End Sub HTH -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam donscarwash wrote : We are looking for a way to program a cell(s) to post the current time when a certain action is done. The idea is like a time clock for our employees to record start times and ending times. It will then be used by other worksheets within the workbook to record employee payroll and other information for our business. ( ex. one keystoke to record current time) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ctrl+shift+arrow does not highlight but ends formula when typing | Excel Worksheet Functions | |||
F9, Shift+F9, Ctrl+Alt+F9 etc | Excel Discussion (Misc queries) | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
CTRL+SHIFT+END | Excel Programming | |||
What does CTRL-ALT-SHIFT-F4 do? | Excel Programming |