Idiot-Proof Forms in Excel - Part 1 - Formatting

Add to Favorites
Author: | Edits: don

Forms Course

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!


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)