Forum Discussion
Solved
TODAY FORMULA VBA
I have a Ageing Analysis workbook where I am using TODAY() formula on cell J3 of Sheet 5 to fetch the current date which will help calculate Overdue days. However, there is a delay when entering data...
You don't need a prompt - the code can enter today's date automatically:
In the Visual Basic Editor, in the Project Explorer pane on the left, double-click ThisWorkbook under Microsoft Excel Objects.
Copy the following code into ThisWorkbook:
Private Sub Workbook_Open() Sheet5.Range("J3").Value = Date End Sub
You don't need a prompt - the code can enter today's date automatically:
In the Visual Basic Editor, in the Project Explorer pane on the left, double-click ThisWorkbook under Microsoft Excel Objects.
Copy the following code into ThisWorkbook:
Private Sub Workbook_Open()
Sheet5.Range("J3").Value = Date
End Sub
thank you Hans.
It works.
It works.