In This Chapter
Finding out when to use UserForms
Understanding UserForm objects
Displaying a UserForm
Creating a UserForm that works with a useful macro
A UserForm is useful if your VBA macro needs to pause and get some information from a user. For example, your macro may have some options that can be specified in a UserForm. If only a few pieces of information are required (for example, a Yes/No answer or a text string), one of the techniques I describe in Chapter 15 may do the job. But if you need to obtain more information, you must create a UserForm. In this chapter, I introduce you to UserForms. You’ll be pleased to make their acquaintance.
Knowing When to Use a UserForm
This section describes a situation in which a UserForm is useful. The following macro changes the text in each cell in the selection to uppercase letters. It does this by using the VBA built-in UCase function.
Dim WorkRange As Range
' Exit if a range is not selected
If TypeName(Selection) <> "Range" Then Exit Sub
' Process only text cells, no formulas ...