Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 83
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 83
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mystery Black line appearing around a group of fields JohnG Excel Discussion (Misc queries) 0 March 3rd 09 12:01 PM
Horizontal Line jryale2008 Excel Discussion (Misc queries) 1 June 18th 08 08:18 PM
Remove Black line above Data which include formulas Apples Excel Discussion (Misc queries) 3 January 16th 08 02:14 AM
Screen Goes Black when Draw Line dee Excel Discussion (Misc queries) 0 October 16th 07 03:36 PM
Horizontal line on line chart Lee Excel Programming 1 March 23rd 05 06:51 PM


All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"