Jun 13, 2003 #1 TopDawg MIS Mar 13, 2001 54 US Is there a way to Have Excel auto insert the date when a user moves his cuser to a cell
Jun 13, 2003 1 #2 Zathras Programmer Nov 12, 2002 3,317 US Yes: [blue] Code: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then [A1] = Date End Sub [/color] (Right-click on the sheet tab and select "View Code" Upvote 0 Downvote
Yes: [blue] Code: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then [A1] = Date End Sub [/color] (Right-click on the sheet tab and select "View Code"
Jun 20, 2003 Thread starter #3 TopDawg MIS Mar 13, 2001 54 US Thanks for the help. Worked great Upvote 0 Downvote