Date entry in a cell in that row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Date entry in a cell in that row

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-04-2019, 10:06 AM

jeffreybrown jeffreybrown is offline

Windows 10 Date entry in a cell in that row

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Hi Phil,

Give this a try on your sheet level code

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Not Intersect(Target, Range("A2:AS21")) Is Nothing Then
        Cells(Target.Row, 46).Value = Format(Now, "mm/dd/yyyy")
    End If
End Sub

Since you want this date in column AT, I changed the target range to only go thru AS

Tags

date auto

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Allow Entry In Cell Based On Value In Another Cell	koltanga	Excel	1	05-07-2017 10:26 AM
How to have one cell show a value based on the entry of another cell?	Marvinapplegate1964	Excel	1	05-04-2016 01:49 PM
Date/Time Entry	ntbluez	Excel Programming	1	03-06-2016 10:12 PM
Restrict Cell Entry	Cardinal2	Excel Programming	1	01-30-2015 08:01 AM
Date/Time Formula for Entry level XL user	talon1driver	Excel	2	09-18-2014 02:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:05 PM.