Idiot-Proof Forms in Excel - Part 1 - Formatting - vTomb

Idiot-Proof Forms in Excel - Part 1 - Formatting

Home
Donate
All
People & Blogs
Entertainment
Music
Gaming
Education
Howto & Style
News & Politics
Science & Technology
Film & Animation
Sports
Comedy
Autos & Vehicles
Nonprofits & Activism
Travel & Events
Pets & Animals

Excel File: https://www.teachexcel.com/excel-tutorial/2112/idiot-proof-forms-in-excel-part-1-formatting?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

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!

TeachExcel.com

By using our services, you agree to our Privacy Policy.
Powered by Wildsbet.

© 2022 vTomb

By using our services, you agree to our Privacy Policy.
Got it