Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Understanding Subroutines.
by Allen Wyatt
(last updated September 25, 2015)
When you write macros, you are using a programming language called Visual Basic for Applications (VBA). This language is based on the BASIC programming language, with extensions specific to Word. One of the features of the languages is the capability to use subroutines in your programs. For instance, consider the following code, written in VBA:
Sub Macro1() TestSub End Sub
Sub TestSub() StatusBar = "In the macro" End Sub
The Macro1 macro does nothing but call a subroutine (TestSub), which in turn prints a message on the status bar. The subroutine then returns control to the main program.
You can have as many subroutines in a macro as you desire. The purpose of each should be to perform common tasks so you don't have to rewrite the same code all the time. You can also pass parameters to your subroutines. These parameters can then be acted upon by your subroutine. For instance, consider the following macros:
Sub Macro1() A = 1 PrintIt A End Sub
Sub PrintIt(x) StatusBar = x End Sub
This is a simple macro that sets a variable, and then passes it in a subroutine call to PrintIt. This subroutine displays the value of the variable on the status bar, and then returns to the calling program. Notice that the subroutine does not use the same variable name as it was passed. This is because VBA reassigns the value of x (what the subroutine expects to receive) so that it matches the value of A (what the program is passing to the subroutine). The important thing to remember in passing parameters to subroutines is that your program must pass the same number of parameters as the subroutine expects, and that the parameters must be of matching types and in the proper order.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11853) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word here: Understanding Subroutines.
Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!
Need to create a directory from within a macro? You can do it using a single command line, as detailed in this tip.Discover More
Part of documenting macros is to provide a good, succinct description of what they do. Changing the description of an ...Discover More
When writing a macro, you may need a way to clear the undo stack. This can be done with a single command, as described in ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.