Excel VBA Programming For Dummies, 3rd Edition

Chapter 16

UserForm Basics

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.

Sub ChangeCase()

    Dim WorkRange As Range

'   Exit if a range is not selected

    If TypeName(Selection) <> "Range" Then Exit Sub

'   Process only text cells, no formulas ...