The Word MVP Site

• Word Home
• Word:mac
• Troubleshoot
• Tutorials
• Find Help
• About Us
• Contact
• Sitemap

• Word on the PC
  • Application errors
  • Customization
  • Drawing/Graphics
  • Formatting
  • General
  • Microsoft Word MVP FAQ
  • Macros/VBA
  • Mail merge
  • Numbering
  • Cross-Application dev.
  • Tables, Fields & Forms
  • Userforms
  • Tutorials

• Word on the Macintosh
  • Troubleshooting
  • Customization

Create a module-level variable that can be used by any procedure (sub or function) within a module

Article contributed by Bill Coan

Any code outside a procedure is referred to as module-level code.

Place the following code at the start of a code module (say, NewMacros) and run each subroutine in turn.

Dim myString As String

Sub Test()
    myString = "Hello"
End Sub

Sub Test2()
    myString = "Goodbye"
End Sub

Sub Test3()
    MsgBox myString
End Sub