00:00I recently published a video on how you can track changes on your Excel spreadsheet so that you know
00:04what changes and when it was made. However, someone had requested if I can also include
00:09field name on my log sheet here. So to start off with, I'm going to add a new column called
00:13field name on the very last column here. And then to edit the VBA, you're going to right click on
00:18the tab and open a VBA code. I have another video dedicated to explaining how this VBA actually
00:24works. If you need this link, please leave a request on the comment section. To populate the
00:28field name column on the log sheet, add the additional line of code at this location targeting
00:33column 6 and invoke the getHeaderTitle function with the argument of target. Next, we'll define
00:37the getHeaderTitle function taking argument of target as range. This function is essentially
00:43going to return the very first row of that column which the user is editing in the dataset,
00:48also known as field name. Ctrl S to save and then close your VBA editor. Test by modifying
00:52the title, first name and employee ID. Go to the log sheet to observe all the changes that
00:57were logged, including the field name.
Comments