If A1 is blank, and A2=blank and a3= Now()
When i enter the name 'Steve' into A1, i want cell A2 to enter the current date (and stay that way forever)
Anyone know how ?
Private Sub Worksheet_Change(ByVal Target As Range)
'Only run macro if a single cell was changed
If Target.Rows.Count > 1 Or Target.Columns.Count > 1 Then Exit Sub
If Target.Row < 5001 And Target.Column = 1 And Target.Value = "Steve" Then
Application.EnableEvents = False
Me.Range("B" & Target.Row).Value = Now
Application.EnableEvents = True
End If
End Sub
On 2002-04-13 14:39, Moradyn wrote:
I entered that, and it works, but only for Steve, is there something that i can change to make it when something is typed in A1 say, any sort of text, like *.*
<----- vba n00bie
(as you have guessed!)
Many thanks
Steve
On 2002-04-13 14:14, dk wrote:
There's no formula which can put the current date/time in a cell which won't update when the worksheet is recalculated (unless someone can prove me wrong).