O'Reilly logo

Excel VBA Programming For Dummies, 5th Edition by John Walkenbach, Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18

UserForm Techniques and Tricks

IN THIS CHAPTER

Bullet Creating a dialog box: A hands-on example

Bullet Working with ListBox controls

Bullet Letting the user select a range from a UserForm

Bullet Showing a progress indicator for lengthy operations

Bullet Creating a stay-on-top dialog box

Bullet Displaying a chart in a UserForm

Bullet 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required