Microsoft Office Forums Date entry in a cell in that row

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2019, 09:10 AM
Phil H Phil H is offline Date entry in a cell in that row Windows XP Date entry in a cell in that row Office 2010 64bit
Advanced Beginner
Date entry in a cell in that row
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default Date entry in a cell in that row


Working range: A2:AT21


If an entry is made in any cell in a row, put today’s date in cell AT.


For example: for row 15, if an entry is madein cell AK15, put today’s date in AT15. If a date already exists, overwrite with today's date.

Reply With Quote
  #2  
Old 11-04-2019, 10:06 AM
jeffreybrown jeffreybrown is offline Date entry in a cell in that row Windows 10 Date entry in a cell in that row Office 2016
Expert
 
Join Date: Apr 2016
Posts: 568
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 11-04-2019, 12:11 PM
Phil H Phil H is offline Date entry in a cell in that row Windows XP Date entry in a cell in that row Office 2010 64bit
Advanced Beginner
Date entry in a cell in that row
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default

Jeff, Thanks for your help - appreciate your time. R/Phil
Reply With Quote
Reply

Tags
date auto

Thread Tools
Display Modes


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
Date entry in a cell in that row 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 entry in a cell in that row Date/Time Entry ntbluez Excel Programming 1 03-06-2016 10:12 PM
Date entry in a cell in that row 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


All times are GMT -7. The time now is 03:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft