Chapter 18

UserForm Techniques and Tricks

In This Chapter

arrow Creating a dialog box: A hands-on example

arrow Working with ListBox controls

arrow Letting the user select a range from a UserForm

arrow Showing a progress indicator for lengthy operations

arrow Creating a stay-on-top dialog box

arrow Displaying a chart in a UserForm

arrow Presenting a handy checklist for creating dialog boxes

The previous chapters show you how to insert a UserForm (which contains a custom dialog box), add controls to the UserForm, and adjust some of the control’s properties. These skills, however, won’t do you much good unless you understand how to make use of UserForms in your VBA code. This chapter provides these missing details and presents some useful techniques and tricks in the process.

Using Dialog Boxes

When you use a custom dialog box ...

Get Excel VBA Programming For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.