How to Use VBA to Add a Date / Time Stamp When You Edit a Record in Excel

One of the most frequent requests that I get from my viewers is: "How can I automatically add a date / time stamp whenever I update, add, or edit a record in Excel?"

Most viewers have already tried to use either the =NOW() Function - a volatile function - or some combination of Keyboard Shortcuts - neither of which are satisfactory procedures.

In this tutorial, I demonstrate how to write a (short) Event-Handler Macro using VBA (Visual Basic for Applications).

If you are "scared" or "intimidated" by the thought of writing VBA Code, you will find that my step-by-step tutorial will show you how easy it is to write this Macro. Try it!

If you need to provide an "Audit Trail" for an Excel worksheet, this VBA Code will save you hours of time by automating the process.

If you are an experienced user of VBA - I have good news for you! I show you the coding early on in this tutorial!

I invite you to visit my new online shopping cart - http://shop.thecompanyrocks.com - to see all of the products that I offer you to "Master Excel in Minutes - Not Months!"

Danny Rocks
The Company Rocks
www.thecompanyrocks.com

Видео How to Use VBA to Add a Date / Time Stamp When You Edit a Record in Excel канала Danny Rocks