Help with time formula so the time will not change.
 

I am in need of help with a formula involving the time. What I need is for
the time to automatically fill in a cell when info is typed into another cell
and to not change. I have the formula =IF(C480,NOW(),"") in cell B48. It
will display the time when I enter info into cell C48, the problem is that
the time keeps changing as I make other changes to the worksheet. Is there
any way I can prevent the time from changing from the original time? Thank
you for your help.

Help with time formula so the time will not change.
 

You can do it with a Change event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then 'column C
Range("B" & Target.Row) = Now
End If
End Sub

Do you know how to install it?

Regards,
Stefi

€žJoker€� ezt Ã*rta:

I am in need of help with a formula involving the time. What I need is for
the time to automatically fill in a cell when info is typed into another cell
and to not change. I have the formula =IF(C480,NOW(),"") in cell B48. It
will display the time when I enter info into cell C48, the problem is that
the time keeps changing as I make other changes to the worksheet. Is there
any way I can prevent the time from changing from the original time? Thank
you for your help.