Is there a way to make the procedure line have a buffer space on the top and the bottom by default?

[Vita]

Procedure separators always underline the last line of code in a procedure which is nice but I think it would look a lot better and more readable if it had a blank line on the top and bottom of it.

Is there a way to do this? I looked in the options menu and didn't see anything.


Maybe a way to use a different editor by default with the alt + f11 key combo?

I know this is a dumb question but thank you for taking the time!

[Micron]

Manually, yes. If you mean automatic, I don't know of a setting. A single quote after a new line then another new line will move the quote below the End Sub but before the separator.

array3 = Split(Join(array2, ",") & "," & Join(array1, ","), ",")

End Sub
'_________________________________________________________________

Function stripAlpha(strIn As String) As String

The space between ' and the line isn't exactly as shown here but it's close I guess.

[Vita]

Manually, yes. If you mean automatic, I don't know of a setting. A single quote after a new line then another new line will move the quote below the End Sub but before the separator.

array3 = Split(Join(array2, ",") & "," & Join(array1, ","), ",")

End Sub
'_________________________________________________________________

Function stripAlpha(strIn As String) As String

The space between ' and the line isn't exactly as shown here but it's close I guess.

I meant automatically but thank you anyways!

[June7]

No automatic feature. I just always Enter a return to get extra space.

[Micron]

That works to move the next line of code down further from the line, but it doesn't work to move the line down from the last line of code which is my interpretation of the problem. At least it doesn't for me. But I don't have a problem with the line being tucked up under End Sub.

[June7]

Right, I Enter a return after last line of code to push the dividing line down and Enter a return after the line to push code down. Enter as many returns as you want.

[Welshgasman]

I dare say someone clever enough could write something with the vba library, but is it worth the effort?

[Micron]

Right, I Enter a return after last line of code to push the dividing line down and Enter a return after the line to push code down. Enter as many returns as you want.

Don't know why that would work for you. Doesn't for me. All it does is add blank lines. The dividing line always remains right under the End Sub.

[June7]

Ooops, my bad memory. I should have looked before I leaped.
Enters just feed into next procedure, as you show.

[orange]

Just did a little looking and it seems that horizontal line comes immediately after End Sub or End Function.
There doesn't appear to be a horizontal line on the last proc in a module. The count of lines in that last proc in a module stops with the End Sub or End Function even if you have blank lines following that line.

Image shows count of BodyLines

Component/Module Name Proc Name ProcedureType NumBodyLines
-------------------------------------------------------------------------------