Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatically insert system time in a cell
I have a s/sheet that needs to automatically have the system time inserted in
a cell if the previous cell is blank. I have tried several things and have not had any joy. Any help offered would be welcome. |
#2
|
|||
|
|||
You can use the select_change event on your sheet capture when a differenet
cell has been selected. Keeping track of prior cell entries can be tracked with a phantom sheet to store prior values, if the prior value was null, then you can send the following command activecell.value = now http://ForPicks.com "PM" wrote: I have a s/sheet that needs to automatically have the system time inserted in a cell if the previous cell is blank. I have tried several things and have not had any joy. Any help offered would be welcome. |
#3
|
|||
|
|||
Hi
as starting point: http://www.mcgimpsey.com/excel/timestamp.html -- Regards Frank Kabel Frankfurt, Germany "PM" schrieb im Newsbeitrag ... I have a s/sheet that needs to automatically have the system time inserted in a cell if the previous cell is blank. I have tried several things and have not had any joy. Any help offered would be welcome. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |