Chapter 20. Creating Advanced User Forms

User forms are a critical part of Microsoft Excel programming in that they provide a surface that is totally under your control with which you can interact with a user. This makes it possible to build more complex Excel applications. Forms can also be used to collect and verify information from a user before it’s entered into a worksheet. They can also be used as part of an add-in to display options and control execution of a particular task. In this chapter, you’ll learn how to build a user form that allows a user to input data into the worksheet, plus how to build an add-in that invokes a multi-step wizard that creates a chart based on selections made by ...

Get Microsoft® Office Excel 2003 Programming Inside Out 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.