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)
 
Back
Top