ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Horizontal black line in VB editor (https://www.excelbanter.com/excel-programming/333272-horizontal-black-line-vbulletin-editor.html)

Hari Prasadh[_2_]

Horizontal black line in VB editor
 
Hi,

If I have more than one Sub in the same module then the VBE draws that
horizontal lines separating the 2 subs from each other. Many times I place
comments before the start and at the end of the sub depending on my whims.
Now, I have problems with the horizontal line when it doesnt know whether a
comment belongs to the sub above or the sub below.

How do I control this line?

Please note, this is the same line inserted by VB just after option explicit
whenever we insert a new procedure.

Thanks a lot,
Hari
India



Vasant Nanavati

Horizontal black line in VB editor
 
I don't think you can. You can avoid this by placing all comments related to
a sub within that sub.

--

Vasant


"Hari Prasadh" wrote in message
...
Hi,

If I have more than one Sub in the same module then the VBE draws that
horizontal lines separating the 2 subs from each other. Many times I place
comments before the start and at the end of the sub depending on my
whims. Now, I have problems with the horizontal line when it doesnt know
whether a comment belongs to the sub above or the sub below.

How do I control this line?

Please note, this is the same line inserted by VB just after option
explicit whenever we insert a new procedure.

Thanks a lot,
Hari
India




Hari Prasadh[_2_]

Horizontal black line in VB editor
 
Hi Vasant

Thnx for your reply.

Thanks a lot,
Hari
India

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
I don't think you can. You can avoid this by placing all comments related
to a sub within that sub.

--

Vasant




Jim Cone

Horizontal black line in VB editor
 
Hari,

You can remove the lines in Tools | Options | Editor(tab) .
Uncheck "Procedure Separator".
Then make your own with '-------

Regards,
Jim Cone
San Francisco, USA


"Hari Prasadh" wrote in
message ...
Hi,
If I have more than one Sub in the same module then the VBE draws that
horizontal lines separating the 2 subs from each other. Many times I place
comments before the start and at the end of the sub depending on my whims.
Now, I have problems with the horizontal line when it doesnt know whether a
comment belongs to the sub above or the sub below.
How do I control this line?
Please note, this is the same line inserted by VB just after option explicit
whenever we insert a new procedure.
Thanks a lot,
Hari
India




All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com