Skip to Content
Word Hacks
book

Word Hacks

by Andrew Savikas
November 2004
Intermediate to advanced
394 pages
9h 6m
English
O'Reilly Media, Inc.
Content preview from Word Hacks

Chapter 7. Macro Hacks

Introduction: Hacks #57-69

When it comes to hacking Word, VBA macros are often the answer. From automating routine tasks to redefining Word’s behavior, macros are a potent weapon in your Word arsenal. The hacks in this chapter show several ways to move beyond basic automation, as well as how to make your macros faster, friendlier, and more flexible.

Get Simple User Input for a Macro

Macros that interact with the user can be very useful. This hack shows you how to get feedback from a user without the overhead or complexity of a VBA UserForm.

When you get input from a user (often yourself), you may want to present the person with several choices. You can use a UserForm with radio buttons or checkboxes, but it might add unnecessary overhead and complexity. Instead, use the dialogs already built into VBA, such as the MsgBox and InputBox.

For example, if you just need the user to select between two choices—say, “Red” or “Blue”—you could display a standard MsgBox with its included “Yes” and “No” buttons. The following macro displays the dialog shown in Figure 7-1:

Sub PickRedOrBluePlease( )
Dim lResponse As Long
lResponse = MsgBox(Prompt:="Press Yes for Red, Press No for Blue", _
                   Buttons:=vbYesNo, _
                   Title:="Pick a color")
If lResponse = vbYes Then
    MsgBox "You picked Red"
Else
    MsgBox "You picked Blue"
End If
End Sub
Hack VBA’s built-in dialogs to get simple user input
Figure 7-1. Hack VBA’s built-in dialogs to get simple ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® Word 2010 In Depth

Microsoft® Word 2010 In Depth

Faithe Wempen
Word 2013 In Depth

Word 2013 In Depth

Faithe Wempen
The Hidden Cost of AI-Assisted Creativity

The Hidden Cost of AI-Assisted Creativity

Léonard Boussioux, Anil Doshi, Oliver Hauser, Kartik Hosanagar

Publisher Resources

ISBN: 0596004931Errata Page