Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 22

Advanced userform techniques

In this chapter, you will:

• Access the UserForm toolbar

• Learn how to use CheckBox, TabStrip, RefEdit, and ToggleButton controls

• Use a collection to control multiple controls

• Select a cell on a sheet while a userform is open

• Use hyperlinks in userforms

• Add controls at runtime

• Add help to a userform

• Set up a multicolumn list box

• Create transparent forms

Chapter 10, “Userforms: An introduction,” covered the basics of adding controls to userforms. This chapter continues the topic, 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, you’ll find a few toolbars that do not ...