Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel auto insert date when user moves to a cell 1

Status
Not open for further replies.

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
 
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")

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top