MM0007 - 13/01/20 - Supporting Data Input in Excel

Something people are doing in Excel all the time?  Inputting data!  Let's look at some cool techniques for making the user experience as smooth as possible, including some cool VBA.

Topics

  •  | What Is Data Validation?
  •  | Create A Dropdown Menu
  •  | Format Dropdown Menus
  •  | Create An Input Message
  •  | How To Support The User
  •  | Create A Custom Input Error Alert
  •  | Cell-based Input Guidance
  •  | Cell Indentation For A Classy Look
  •  | IF
  •  | Avoid Hard Coding In Formulae
  •  | Named Range Naming Conventions
  •  | Conditional Formatting Rules Manager
  •  | Create A Conditional Formatting Rule
  •  | Cell And Sheet Protection
  •  | Validate Cell Inputs Using VBA
  •  | ADDRESS
  •  | ROW
1 Lesson