Solved automatic current date in Excel 7

October 29, 2013 at 11:46:08
Specs: Windows 7
I'm trying to get with an automatic single click the current date in col A without having to enter each time - can you help

See More: automatic current date in Excel 7

Report •

October 29, 2013 at 14:02:39
✔ Best Answer
In it's simplest form, this code will place the date in any cell in Column A as soon as you select the cell.

If you need to limit this action to a specific range, you'll have to let us know.

Right click the sheet tab for the sheet you want to do this in and choose View Code. Paste the code below into the pane that opens, then select a cell in Column A.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 If Target.Column = 1 Then Target = Date
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question