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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Date/Time when click on cell
This is not your personal service if you want it come and get it
Private Sub Worksheet_SelectionChange(ByVal Target As Range Set isect = Intersect(Target, Range("A:A") If Not isect Is Nothing Then Target.Value = Now( End Su ----- MAGICofSeth wrote: ---- 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Date/Time when click on cell
On Sun, 16 May 2004 19:05:07 -0500, MAGICofSeth
wrote: 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 and time are entered into that cell only. If I were to click on a different cell in that column, the current date and time would automatically be placed into that's cell only. Therby, two different times at least would be displated in two different cells which were clicked only clicked on a few moments apart. The date and time need to be unchanging after it is "clicked" in. (not constantly updating with the current date and time) which is my problem. That is all. If people could please email answers or VBA code to me at: I would really be grateful. Thank You! --Seth --- Message posted from http://www.ExcelForum.com/ See answer in another excel newsgroup to which you posted this identical message! --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Date/Time when click on cell
Private Sub Worksheet_SelectionChange(ByVal Target As Range
If Target.Cells.Count 1 Then Exit Su If Target.Row <= 8 Then Exit Su Set isect = Intersect(Target, Range("A:A") If Not isect Is Nothing Then Target.Value = Now( End Su ----- chris wrote: ---- This is not your personal service if you want it come and get it Private Sub Worksheet_SelectionChange(ByVal Target As Range Set isect = Intersect(Target, Range("A:A") If Not isect Is Nothing Then Target.Value = Now( End Su ----- MAGICofSeth wrote: ---- 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 |
Reply |
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 |