Chapter 19
UserForm Techniques and Tricks
IN THIS CHAPTER
Creating a dialog box: A hands-on example
Working with ListBox controls
Letting the user select a range from a UserForm
Showing a progress indicator for lengthy operations
Creating a stay-on-top dialog box
Displaying a chart in a UserForm
Presenting a handy checklist for creating dialog boxes
Earlier chapters show you how to insert a UserForm (which contains a custom dialog box), add controls to the UserForm, and adjust some of the controls’ properties. These skills, however, won’t do you much good unless you understand how to make use of UserForms and controls 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access