date stamp

[kamranyd]

vba codes for automatically date appear in a cell of whatever sheet i want. whenever i open workbook

 

[alansidman]

Put this in the Workbook Open Event in the VBE. Change the Range to whatever cell you wish to have the Date appear.

Option Explicit


Private Sub Workbook_Open()
Range("A1") = Date
End Sub

 

[kamranyd]

Option Explicit
Private Sub Workbook_Open()
Sheets("QUOT").Range("J13").Value = Date
End Sub

I wrote these codes as i need date on a specific sheet.