Need help with automatic date entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a sheet used as a data base, how do I have the current date updated or
changed when the data changes in a record or row. I would like this to show
when that record has been modified with out manually changing that cell.
 
Hi

Rightclick the sheet tab, choose "view code", paste this macro in:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target(1).Column < 5 Then _
Cells(Target(1).Row, 5).Value = Now

End Sub

Replace 5 with whichever column number your dates are stored in.

HTH. Best wishes Harald
 
You can do this with a worksheet_change event macro which is told to use
date in the cell if cells in the row have changed.
 
You must log in or register to reply here.

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

Excel Vba to change displayed year automatically. 14
Remove date format? 3
Access How to record date/time when specific field is modified in Access 2007 0
How do a set the current date to change in cell everyday 1
Automatic Data Changes 1
How to change cell contents based on date? 2
VBA to automatically cut, paste entire row based on date input and delete row 0
Changing dates automatically with the computer date 2

Back
Top