Is there any way to collapse/expand codes in VBA editor?

  • Thread starter Thread starter iop
  • Start date Start date
I

iop

How to expand/collapse the codes in VBA programming window?
is there any plug-in or software to make it?
thanks!
 
I know of no way to do exactly what you want (wish I did), but you can set
it up so that the window only shows one procedure at a time
(Tools>Options>Editor>Window Settings>Default to Full Module View - uncheck
it). I don't like it, but it is available.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
thanks.
though we can switch the views of one / all procedure(s) by clicking the
bottom left of the editor window, only showing the one procedure is not
enough. ;)
codes with "if... then", "while,... wend", etc, especially need to be
collapsed and expanded.
it can be done in Visual Basic 2008.
it seems we've to wait for the next version of VBA. :(
 
There isn't going to be a 'next version of VBA'.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse 2
Programming Outline Expand(+) / Collapse(-) Functionality 4
Collapsing all groups 0
cannot expand outline on protected sheet 2
VBA: Collapse Column Groupings 1
Open / Close Grouping through VBA 13
Word The More add-in for Microsoft Word 0
Expand/collapse toolbar ribbon 6

Back
Top