Creating a macro that inserts the current date into a cell
For a guide to how to edit macros for your own purposes, please click here.
In this video we outline how to create a macro that inserts the current date into a newly created cell. This is useful if you are creating new rows and would like this to also populate a certain field with the current date that this occurs.
The code that we used in this tutorial is as follows.
Private Sub CommandButton1_Click()
Selection.Borders.Weight = xlThin
ActiveCell.Formula = “=today()”
You will need to tailor the range to suit your own requirements on your own spreadsheet within the code.
To download a copy of this workbook then please click the link below.
If this has been helpful then please like or subscribe to the channel.