auto date

  • Thread starter Thread starter albert
  • Start date Start date
A

albert

I would like to set up an autodate in an excel spreadsheet. I want the date
to fill when I enter data into the previous cell, but I do not want the date
to change when the report is updated or saved. Is this possible in excel. I
do not want to take the form to access because of user issues.
 
Albert,

Try this code in the Worksheet Selection_Change event:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Enter the address you want to use here
If Target.Address = "$B$1" Then
If Target.Value = "" And Target.Offset(0, -1).Value <> "" Then
Target.Value = Now()
End If
End If
End Sub

HTH

Troy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Date 4
today's date static 1
Excel 2 into 1 6
insert date automatically changes previous dates to new date? 2
Date formats 3
how do I get autodate to stay the date it was saved 3
auto date reminder in excel 1
Excel Date Setting 1

Back
Top