Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To Capture the time stamp on entry of a value in cell.
Hi,
I am trying to capture the time on the entry of the cell in column A. Scenario is I enter a person code in cell in A column and in B column I need a time stamp. I am using now(). It works for one row. but as i proceed to scan further all the values in column b is getting updated as i am using now(). I want to capture time stamp for each entry of person code in col A and then freeze timestamp in col b and proceed. I am trying to get something like, A1 3031 B1 10:30 Pm A2 3032 B2 10:35 PM and so on... Any pointer or help here will help me. Thanks in advance. best regards, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
To Capture the time stamp on entry of a value in cell.
Try this:
Private Sub Worksheet_Change(ByVal target As Range) If target.Column = 1 Then target.Offset(0, 1).Value = Now() End Sub -- Frank "Do or do not; There is no try" -Yoda "Khozema Sherwala" wrote: Hi, I am trying to capture the time on the entry of the cell in column A. Scenario is I enter a person code in cell in A column and in B column I need a time stamp. I am using now(). It works for one row. but as i proceed to scan further all the values in column b is getting updated as i am using now(). I want to capture time stamp for each entry of person code in col A and then freeze timestamp in col b and proceed. I am trying to get something like, A1 3031 B1 10:30 Pm A2 3032 B2 10:35 PM and so on... Any pointer or help here will help me. Thanks in advance. best regards, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
To Capture the time stamp on entry of a value in cell.
Thanks it works. I understand the range type is being used and if my cursor
is on first column then only time is populated in the next column cell values only. It works for my today's assignment. Thanks Phuelgod. "Khozema Sherwala" wrote: Hi, I am trying to capture the time on the entry of the cell in column A. Scenario is I enter a person code in cell in A column and in B column I need a time stamp. I am using now(). It works for one row. but as i proceed to scan further all the values in column b is getting updated as i am using now(). I want to capture time stamp for each entry of person code in col A and then freeze timestamp in col b and proceed. I am trying to get something like, A1 3031 B1 10:30 Pm A2 3032 B2 10:35 PM and so on... Any pointer or help here will help me. Thanks in advance. best regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stamp a Cell with Time Q | Excel Programming | |||
How do I lock a stamp date/time formula for an entry on a row? | Excel Worksheet Functions | |||
Time stamp macro to capture changes from one workbook to another | Excel Programming | |||
date time stamp excel activity log entry? | Excel Programming | |||
time stamp a cell that doesn,t change when time stamping another | Excel Programming |