How to Auto-populate the Date in Excelby Jaime AvelarUpdated September 28, 2017
Having the user enter a date in your Microsoft Office Excel application can be time-consuming and frustrating if the user uses the workbook often. In Excel, you can add a formula to a particular cell where you need to display a date. Visual Basic for Applications can also be used to automate populating the date in Excel. The “NOW()” function is used to populate the date in Excel using either method.
Launch Microsoft Office Excel and click “A1” on your spreadsheet. Press “F2” and type the following to auto-populate the system date:
Click the “Developer” tab and click “Visual Basic” to open the Visual Basic Editor. Click the “Insert” menu and click “Module” to add a new module.
Copy and paste the following code to populate the date in “B2” using VBA:
Private Sub autoPopulateDate()
Press “F5” to run the procedure.
- Stockbyte/Stockbyte/Getty Images