Channel: TeachExcel

Category: Education

Tags: track cell changesvba alert systemrun macro when a cell changesexcel tracker

Description: Downloadable File: teachexcel.com/vba-mini-projects/130/vba-cell-change-tracker?src=yt_description_aute1uum9p8 Full VBA Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_aute1uum9p8 Never miss an important Excel data point change again! How to build a Cell-Change Tracker for Excel that will alert the user when certain cells have changed or reached a certain value or threshold. This system is managed from the worksheet so that, once it's setup, a regular non-VBA user can manage it. In addition to showing an alert to the user, using this system, you can have a cell-change automatically run any series of macros or code, such as: - Email a manager if a value becomes critical. - Lock or close a workbook. - Log a user out of a custom login system (like the one I showed you how to make in the previous tutorial). - Force the user to update or correct the value. - Much more. To build even more powerful VBA projects or further customize this one, checkout my full VBA Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_2_aute1uum9p8 #msexcel #vba #tutorial