Idiot-Proof Forms in Excel - Part 1 - Formatting

Add to Favorites
Author: | Edits: don

How to make an IDIOT-PROOF Form in Excel! (Part 1)

 

Part 2 (Validation): https://www.youtube.com/watch?v=pkGJajzQzBE

Part 3 (Macro & Error Display): https://www.youtube.com/watch?v=sziCyblAlbU

Part 4 (Protect the Form): https://www.youtube.com/watch?v=EOfhnbtjIY0

 

This tutorial shows you how to create a form within a regular worksheet in Excel that a user can never mess-up, edit, augment, change, or do anything with except input the data that they are supposed to input.

I show you how to force the user to use only certain cells for input; how to control the type and format of the data input into the spreadsheet; how to validate and apply special error-checking formatting to the form; and, then how to attach a macro and security features to the macro so that no one can ever change it without your permission.

This is the first part of a 4 part series and this tutorial will focus on the initial formatting and setup of the form.

Enjoy!

Question? Ask it in our Excel Forum


Downloadable Files: Excel File