bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Macros > WordBasic Examples > Understanding the Select Case Structure

Understanding the Select Case Structure

Summary: One very helpful programming construct is the Select Case structure. It allows you to set up a series of “triggers” that will execute different blocks of programming code. This tip explains how you can use a Select Case structure in your own macro programming. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

Macros in Word are written in a language called VBA. Like any other programming language, VBA includes certain programming structures that are used to control how the program executes. One of these structures is the Select Case structure. This structure has the following syntax:

Select Case expression
Case expression
    program statements
Case expression
    program statements
Case Else
    program statements
End Select

When a macro is executing and this structure is encountered, Word uses the expression (first line) to test each subsequent Case statement to see if the code under the Case statement should be executed. For instance, consider the following code:

Select Case DayOfWeek
Case 1
    DayName = "Monday"
Case 2
    DayName = "Tuesday"
Case 3
    DayName = "Wednesday"
Case 4
    DayName = "Thursday"
Case 5
    DayName = "Friday"
Case 6
    DayName = "Saturday"
Case 7
    DayName = "Sunday"
Case Else
    DayName = "Unknown day"
End Select

This code assumes you enter it with DayOfWeek already set to a numeric value. Let's say (for example's sake) the value is 4. In this structure, the only code that would be executed is the code under the Case 4 statement--in other words, the macro would set DayName to "Thursday." If DayOfWeek were set to some other value not accounted for by the Case statements (outside of the 1 to 7 range), then the code under Case Else would execute, and the macro would set DayName to "Unknown day."

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


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!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)