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(C48>0,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.

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(C48>0,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.