Consulting

Results 1 to 6 of 6

Thread: Solved: Testing code comments

  1. #1
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location

    Solved: Testing code comments

    Test 1
    [VBA]
    If IsDate("31/1/01") Then
    'UK Date format
    Else
    'US Date format
    End If
    [/VBA]

    Test 2
    [VBA]Sub Yellow()
    With Selection.Interior
    If .ColorIndex = 6 Then
    'Remove colour
    .ColorIndex = xlNone
    Else
    'Set colour
    .ColorIndex = 6
    End If
    End With
    End Sub
    [/VBA]

  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    [vba]
    'test
    ''test2
    '''test3
    ' test4
    ' ' test 5
    ' ' ' test6
    [/vba]
    So what happened to the VBA code comments?

  3. #3
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Zack,
    They got posted in the email instead!

    Hello mdmackillop,

    firefytr has just replied to a thread you have subscribed to entitled - Testing code comments - in the Testing Area forum of VBA Express Forum.

    This thread is located at:

    http://www.vbaexpress.com/forum/showthread.php?t=1790&goto=newpost

    Here is the message that has just been posted:

    ***************

    'test

    ''test2

    '''test3

    ' test4

    ' ' test 5

    ' ' ' test6

    ***************



    There may be other replies also, but you will not receive any more notifications until you visit the forum again.

    Yours,

    The Team of Coders at VBA Express Forum


  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    I'll let Mark007 know about this.

  5. #5
    BoardCoder
    Licensed Coder VBAX Expert mark007's Avatar
    Joined
    May 2004
    Location
    Leeds, UK
    Posts
    622
    Location
    Doh - sorted now, thanks for the spot!

    "Computers are useless. They can only give you answers." - Pablo Picasso
    Mark Rowlinson FIA | The Code Net

  6. #6
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Thanks Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •