Idiot-Proof Forms in Excel - Part 2 - Validation

Add to Favorites
Author: | Edits: don

Forms Course

This tutorial shows you how to create and use a unique data validation setup that will allow you to create powerful error-checking forms in Excel.

Learn how to apply data validation to your form! This limits what the user can input into a cell so that you can prevent them from putting bad values, outdated values, out-of-range values, etc. into the form.

I'll show you simple data validation and also complex custom data validation.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.