Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Date/Time when click on cell
As per the instructions, I will get straight to the point.
I would like to have a column of cells from "A9" down to "A(infinity) that when I click on a single cell in that column, the current date an time are entered into that cell only. If I were to click on a differen cell in that column, the current date and time would automatically b placed into that's cell only. Therby, two different times at leas would be displated in two different cells which were clicked onl clicked on a few moments apart. The date and time need to be unchanging after it is "clicked" in. (no constantly updating with the current date and time) which is m problem. That is all. If people could please email answers or VBA code to me at I would really be grateful. Thank You! --Set -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time entry auto changes to date and then time ? | Excel Worksheet Functions | |||
Click a cell and update to current time / date ? | Excel Discussion (Misc queries) | |||
Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel |