Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 23. Advanced Userform Techniques

IN THIS CHAPTER

Using the UserForm Toolbar in the Design of Controls on Userforms	493
More Userform Controls	493
Controls and Collections	501
Modeless Userforms	503
Using Hyperlinks in Userforms	504
Adding Controls at Runtime	505
Adding Help to the Userform	510
Multicolumn List Boxes	513
Transparent Forms	514
Next Steps	515

Chapter 10, “Userforms—An Introduction,” covered the basics of adding controls to userforms. This chapter continues on this topic by looking at more advanced controls and methods for making the most out of userforms.

Using the UserForm Toolbar in the Design of Controls on Userforms

In the VB Editor, hidden under the View menu in the Toolbars command are a few toolbars that don’t appear unless the ...