Mastering VBA for Microsoft Office 365, 2019th Edition

Chapter 13Getting User Input with Message Boxes and Input Boxes

This chapter shows you how to build a user interface for your macros.

You'll learn the three easiest ways of communicating with the user of your macro, the two easiest ways of enabling the user to provide information to your code, and the easiest way of soliciting input from the user. Along the way, you'll see how to decide what the best way to communicate with the user is in any given set of circumstances. This will set the scene for crafting more complex user interactions via custom dialog boxes, later in the book.

In most Office applications, VBA offers you a choice of up to five ways of communicating with the user of a macro:

• Displaying a message on the status bar at the ...