comments location in vba -opinion not question

[lezawang]

Hi
Where you usually write the comment about the sub you are writting? I created macro by recording steps and under Descrition: I wrote testing to my surprise excel created this code

Sub Macro3()
'
' Macro3 Macro
' testing
'


'
   
End Sub

I was expecting this

' Macro3 Macro
' testing
Sub Macro3()
End sub

Which style you do? Thanks

 

[Rick Rothstein]

In my "early days" (I have been programming since 1981), I use the first method mainly because that is what others used; however, in my "later days" prior to my retirement (I retired in 2002), my preference was for the second method... I liked keeping internal comments reserved for explaining code lines and the external comment for a description of what the code is about/doing/for.

 

[Michael M]

I prefer the former....simply because that's what VBA does and that's what the majority expect ( I think !)
But having said that, Ricks comments make a lot of sense !!