Expand / collapse VBA chunks

  • Thread starter Thread starter Rajat
  • Start date Start date
R

Rajat

Hello,

Is there a way I can expand / collpase chunks of VBA code?

These logical chunks are separated by empty lines.

Thanks,

Rajat
 
Rajat said:
Hello,

Is there a way I can expand / collpase chunks of VBA code?

These logical chunks are separated by empty lines.
Click to expand...

I have no idea what you mean. Could you explain?
 
In the lower left corner of the VBA code window there are two small buttons -one is for procedure view, the other is for module view (at least they're there on my A2K3 version). Other than that, I know of no way to expand / collapse the text in the code window.
 
There's a feature in VS.NET where you can define 'regions' of code like so
....

#Region "My Region"
....
#End Region

You can then expand and collapse those regions by clicking on + and -
symbols, like outlining in Word. To see it in action, create a new Windows
Forms application in VS.NET, and in the code behind the default "Form1",
click the + symbol beside "Windows Form Designer generated code".

The answer, of course, is no, the VBA editor does not implement such a
feature.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top