Word Document Properties

Part I: An Overview of VBA 
06_046500 ch02.qxp 12/5/06 5:33 PM Page 36

---

The 
MsgBox
function is capable of doing more than the Chapter 1 example
shows. First, the function can return a 
Result
that shows which button the
user selected. The 
Result
variable holds the selection information so that
you can use it in other ways. You can also tell 
MsgBox
which buttons to dis-
play and to provide a title. Here’s a more advanced version of the 
MsgBox
function that I use in Chapter 1 — type this line directly beneath the 
‘Display the message box
comment:
Result = MsgBox(“Click a Button”, vbYesNoCancel, “A
Message”)
This code tells VBA to display a message box with 
“Click a Button”
as
the text and 
“A Message”
on the title bar. The message box includes the
Yes, No, and Cancel buttons. After VBA displays the message box, it waits for
the user to make a decision. When the user clicks one of the three buttons,
VBA stores the choice in the 
Result
variable. Wow, that’s a lot for one piece
of text to do!
The pseudo-code says that the code needs to detect which button the user
pressed. You can use another message box to display the information like this:
MsgBox Result
This is the same technique that I use in Chapter 1. The only difference is that
the information contained in 
Result
relies on a user selection. You don’t
know in advance which button the user will select, but this code works no
matter which button the user clicks.
The final piece of pseudo-code says that VBA should end the program. You do
this with the 
End Sub
statement shown in Figure 2-1. Whenever VBA runs
out of instructions to process, it ends the program. Figure 2-2 shows what
your code should look like now. Make sure that you save the code at this
point by using the File
➪
Save command.
Figure 2-2:
Writing
code is easy
when you
use pseudo-
code to
describe
it first.
37