adding comments to code

[graemeal]

How do you add a comment within a code on a post which turns it into blue text. Such as the '-- or whatever range you want.

Thanks

If CheckedRange Is Nothing Then
        Set CheckedRange = Me.Range("A1:A2") '-- or whatever range you want
        CellsCount = CheckedRange.Cells.Count
        ReDim OldValue(1 To CellsCount)
        For i = 1 To CellsCount
            OldValue(i) = CheckedRange(i)
        Next
    End If
End Sub

XP XL2007

 

[starl]

You mean when posting code to the board? If so - wrong forum, which makes this difficult to understand.. But if that is the question, then the answer is: http://www.mrexcel.com/vbaddin.shtml

If it's *not* what you mean.. can you try explaining again?

 

[graemeal]

Yes that is what I was after. Thank you very much. Still working my way around the do's and dont's of the site.

Thanks

 

[starl]

No biggee - I moved it where it may be more helpful. But the forum can affect the context of your post

 

[Peter_SSs]

You can also just colour it manually within the code tags.

If CheckedRange Is Nothing Then
    Set CheckedRange = Me.Range("A1:A2") '-- or whatever range you want
    CellsCount = CheckedRange.Cells.Count
    ReDim OldValue(1 To CellsCount)
    For i = 1 To CellsCount
        OldValue(i) = CheckedRange(i)
    Next
End If

 

[graemeal]

Thanks Peter but excuse my ignorance. How is that done? It was the first thing I looked for.

 

[Peter_SSs]

Thanks Peter but excuse my ignorance. How is that done? It was the first thing I looked for.

Click the 'Quote' button at the bottom of my previous post and you will see the code tags that apply the blue colour.

When using the Quick Reply window you should see some formatting options including font colour just above that window - unless in your User CP|Edit Options|Message Editor Interface you have it set to Basic Editor. (I normally have mine set to Standard Editor)

 

[Smitty]

Personally, I'm a big fan of the VBHTML Maker. PM me your e-mail address and I'll send you a copy.

 

[Jon von der Heyden]

I like the output of this one too.

 

[Peter_SSs]

Personally, I'm a big fan of the VBHTML Maker. PM me your e-mail address and I'll send you a copy.

Me too, and that is what I normally use. It can also be downloaded directly from the link in Tracy's post (#2) above.

However, sometimes I like to use this manual method to highlight a change to some previously posted code.