How to start a macro when a worksheet changes
In this tutorial you will learn how to start a macro when a worksheet changes. This is a follow up tutorial from the creating a macro tutorial. In that tutorial, the goal was to have a macro that would sort records automatically when a new line was added. In order to run this macro automatically when the worksheet changes, you need to add the macro code in the "worksheet change" function. Excel has many automated functions that run based on events like before saving the workbook, when the workbook changes, etc. More details about these functions here in the...read more