Auto Alert When Cells Change in Excel - VBA Mini Project
15.9 هزار بار بازدید -
3 سال پیش
-
Downloadable File: https://www.teachexcel.com/vba-mini-projects/130/vba-cell-change-tracker?src=yt_description_aute1uum9p8
Full VBA
Downloadable File: https://www.teachexcel.com/vba-mini-projects/130/vba-cell-change-tracker?src=yt_description_aute1uum9p8
Full VBA Course: https://www.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: https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_2_aute1uum9p8
#msexcel #vba #tutorial
3 سال پیش
در تاریخ 1400/11/19 منتشر شده
است.
15,968
بـار بازدید شده