Hi DK
Are you really sure you want to do this? It will mean you can’t enter anything but a date in that column.
If you’re sure
- Right click on the sheet’s name tab at the bottom of the page
- Select view code
- Select ‘Worksheet’ From the left drop-down menu at the top of the page, and ‘SelectionChange’ from the right menu. This should automatically set up a private sub for you
- Type in the date change code so your macro looks like this:
return to the sheet, and it should inset the date and time whenver you click in the first column
Bookmarks