| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to insert time of day in excel cell
How can I set up an excel worksheet to track time so that when I click on the
required excel cell it automatically inserts time of the day |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to insert time of day in excel cell
right click the sheet tabview codedouble_click event
Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, Cancel As Boolean) If Target.Address < _ Range("k1").Address Then Exit Sub Target = Time End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "novice567" wrote in message ... How can I set up an excel worksheet to track time so that when I click on the required excel cell it automatically inserts time of the day |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Function next to formula bar gives Run-time Error '50290' | Excel Discussion (Misc queries) | |||
| Insert newline in cell through formula (excel 2003) | Excel Worksheet Functions | |||
| how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
| how do i insert the current time into a cell, and show different . | Excel Discussion (Misc queries) | |||
| automatically insert system time in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
