Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Arranging Document Windows

Specifying a Backup Location

Controlling Chart Gridlines

Merging Table Cells

Collapsing and Expanding Subdocuments

Zooming With the Keyboard

Initiating a New Search

 

Understanding the If ... End If Structure

Summary: One of the powerful programming structures provided in VBA allows you to conditionally execute commands. The If … End If structure is easy to implement once you grasp what it does. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

Macros in Word are written in a language called Visual Basic for Applications (VBA). Like any other programming language, VBA include certain programming structures used to control how the program executes. One of these structures is the If ... End If structure. The most common use of this structure has the following syntax:

If condition Then
    program statements
Else
    program statements
End If

When a macro is executing, and this structure is encountered, Word tests whatever condition you have specified following the If keyword. If the condition is true, then the program statements right after the Then keyword are executed. If they are not true, then the statements after the Else keyword are executed. The Else keyword and any following program statements (which together make up an Else clause) are optional; you do not need to include them in your macro.

Regardless of whether the program statements in the If ... End If structure are executed, when Word is done with the structure, the macro continues running with the statement following the End If keyword.

Tip #125 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want.
 
Check out WordTips: The Macros today!