VBA and Macros for Microsoft Excel

21Advanced UserForm Techniques

IN THIS CHAPTER

Using the UserForm Toolbar in the Design of Controls on UserForms

Controls and Collections

More UserForm Controls

Tabstrip

RefEdit

Modeless Userforms

Hyperlinks in Userforms

Adding Controls at Runtime

Using a Scrollbar as a Slider to Select Values

Adding Help Tips to Controls

Tab Order

Coloring the Active Control

Case Study: Multicolumn ListBox

Transparent Forms

Next Steps

Chapter 9, “UserForms—An Introduction,” covered the basics of adding controls to forms. 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 Visual Basic Editor, hidden ...