MENU

Fun & Interesting

Idiot-Proof Forms in Excel - Part 3 - Macro and Error Display

TeachExcel 43,068 lượt xem 6 years ago
Video Not Working? Fix It Now

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

Comment