Written by Allen Wyatt (last updated March 20, 2021)
This tip applies to Word 97, 2000, 2002, and 2003
If you need to get input from a user under control of a macro, one method you can use is to employ the InputBox function. This function displays a dialog box and allows the user to type a response. The result is a string, returned to your macro, which you can then process and use.
The syntax for the InputBox function is as follows:
sMyString = InputBox(sPrompt, sTitle, sDefault)
There are three parameters you can use with InputBox, although only the first one is absolutely required. In this syntax, sPrompt is the text you want displayed as the user prompt, sTitle is the text to display in the title bar of the dialog box, and sDefault is the default text string offered to the user in the dialog box. The user can edit or accept the default string, as desired.
As an example, the following code lines can be used to display a dialog box and ask the user for his or her name:
sPrompt = "Please check your name and make any corrections" sTitle = "Name Entry" sDefault = "John Doe" sUserName = InputBox(sPrompt, sTitle, sDefault)
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1356) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Getting User Input in a Dialog Box.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
If you want a list of all the fonts used in a document, the answer isn't as simple as you may think. This tip uses macros ...
Discover MoreNot satisfied with the detail provided by the Word Count feature in Word? Perhaps you want to actually know where every ...
Discover MoreIf you need to determine a random value in a macro, you can do so using the Rnd function. This tip presents the syntax ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-04-19 12:22:55
James
Allen, I was really excited about this tip, so I built some macros with your suggestion that solicits user input. Quite easy. Thanks!.
However, the user needs to scroll though this document or another document to find, copy, and/or paste the the desired input. However, Input Box is locked (Modal). How to make this modelesss in Word (e.g. as in excel's Application.input)?
Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments