PART II
A Real World Example
In this part, you examine and investigate a real world example based on many of the core concepts introduced in the first part. This real-world example is inspired by a real spreadsheet I developed for a client.
Chapter 6 proposes a new method of taking in user input by using the spreadsheet rather than ActiveX controls and UserForms. You begin by investigating a very simple Excel-based input form and learn how custom formats can aid in form validation. You then move onto a more complicated example of user input—a spreadsheet-based wizard. You spend the rest of the chapter reverse engineering the components of the ...
Get Advanced Excel Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
