Excel® 2013 VBA and Macros

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

Creating Transparent Forms

Next Steps

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, under View, Toolbars, are a few toolbars that do not appear unless the user selects them. One of these is the UserForm toolbar, shown in Figure 22.1 ...