Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL
Need to store the Date & Time whenever a value is entered to a cell.
If a value is entered to celle B3 then the current date & time should be saved in C3. I used the following in cell C3 =IF(B3<"", NOW()," " ) But whenever any operation is done in a cell the Date & Time gets the current value which I dont want to happen. Thanks Asoka |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL
You need an event sub for that:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "B3" Then Cells(Target.Row, Target.Column + 1) = Date + Time End If End Sub This works only for B3, post if you want to expand its range or need help to install it! Regards, Stefi €žAsoka Walpitagama - Brandix College IT€ť ezt Ă*rta: Need to store the Date & Time whenever a value is entered to a cell. If a value is entered to celle B3 then the current date & time should be saved in C3. I used the following in cell C3 =IF(B3<"", NOW()," " ) But whenever any operation is done in a cell the Date & Time gets the current value which I dont want to happen. Thanks Asoka |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i see the date the last time a cell was changed? | New Users to Excel | |||
permanent time and date stamp for Excel --- so it cant be changed | Excel Discussion (Misc queries) | |||
when i enter time in cell it changed, why? | Excel Worksheet Functions | |||
Pull and store a value on specific date in another cell | Excel Worksheet Functions | |||
store file saved date in cell | Excel Worksheet Functions |