software

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(C48gt;0,NOW(),quot;quot;) 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(quot;Bquot; amp; Target.Row) = Now
End If
End Sub

Do you know how to install it?

Regards,
Stefi

?oker??ezt ?rta:

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