VBA and Macros: Microsoft® Excel® 2010

23. Advanced Userform Techniques

IN THIS CHAPTER

Using the UserForm Toolbar in the Design of Controls on Userforms

More Userform Controls

Controls and Collections

Modeless Userforms

Using Hyperlinks in Userforms

Adding Controls at Runtime

Adding Help to the Userform

Transparent Forms

Chapter 10, “Userforms: An Introduction,” covered the basics of adding controls to userforms. This chapter continues 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 do not appear unless the user intervenes. One of these is the UserForm toolbar, shown in ...