Full Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_sziCyblAlbU
How to make an IDIOT-PROOF Form in Excel! (Part 3)
Excel File: https://www.teachexcel.com/excel-tutorial/2114/idiot-proof-forms-in-excel-part-3-macro-amp-error-display?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt
Part 1 (Formatting): https://www.youtube.com/watch?v=9j8mAJGFWPg
Part 2 (Validation): https://www.youtube.com/watch?v=pkGJajzQzBE
Part 3 (Macro & Error Display): This Tutorial
Part 4 (Protect the Form): https://www.youtube.com/watch?v=EOfhnbtjIY0
How to apply custom conditional formatting combined with custom data validation in order to make powerful error-checking features for your form.
This tutorial combines concepts from the previous tutorial as well as new concepts and macros and brings them all together to get our idiot-proof form up and running.
After this tutorial, you will have a fully functioning error-checking and reporting form.
Enjoy!
TeachExcel.com