Insert Date in Next Column When Entering Data

[DonAckerman]

I'm a newbie trying something that might be simple.

When I type data in column B, I'd like column C to automatically fill in today's date.

That's it. It has to be easy, but I haven't figured it out. Thanks in advance for the help!

 

[SteveO59L]

something along the lines of

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Target.Offset(0, 1) = Time
End If

End Sub

 

[Joe4]

Welcome to the Board!

Note: Be sure to paste the code Steve provided above in the proper Sheet VBA module.
An easy way to get there is to right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste into the resulting VBA window.

 

[DonAckerman]

When I run the above, I get "Run-time error '424': Object required"
I'm brand new at this so appreciate the help as I learn.

 

[DonAckerman]

That helps, Joe4! I am new so this is awkward and slow.

I did change "Time" to "Date" and used your tip. That's working thus far.

 

[DonAckerman]

Thanks, @SteveO59L. I appreciate the time.

 

[SteveO59L]

no probs