« I’m a Geek
Formatting Footers in VBA »

Magic Colon

January 06, 2005, 9:55 am by Dick Kusleika

Here’s a new one on me via some Access MVPs. Type this:

Sub test()
 
If True Then
    Debug.Print
    Else Debug.Print

and you’ll get this

Sub test()
 
If True Then
    Debug.Print
    Else: Debug.Print

The VBE automagically makes the Else line a multi-statement line by inserting a colon. Just when you think you know a program. Now that I know it, I’ll still never use it.

Category: VBA  |  Comment (RSS)  |  Trackback

One Comment

To post VBA code in your comment, use <code> tags, like this: <code lang="vb">Code goes here</code>.

Leave a Reply