Organizing the VBE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 20 Sep 2007 17:44 GMT

Does anybody know of any ways to organize the VB Editor? I have quite
a few subroutines and my editor is getting pretty long. In VB.NET,
you can create "regions" that allow you to group conceptually similar
subroutines together and then collapse them when you are not currently
working with them. I tried this in VBA, but it didn't work. Can
anybody suggest anything?

Thanks,
Randy

Reply to this Message

Dave Peterson - 20 Sep 2007 18:16 GMT

You could use multiple modules to organize your procedures.

Or you could use the two icons at the left of the horizontal scroll bar of the
code window.

One icon looks like:
----
---
----

The other looks like
----
---
----
---
----

The leftmost icon will give you a procedure by procedure view of the code
window. The icon on the right shows all the procedures in that module.

> Does anybody know of any ways to organize the VB Editor? I have quite
> a few subroutines and my editor is getting pretty long. In VB.NET,
[quoted text clipped - 5 lines]
> Thanks,
> Randy

Signature

Dave Peterson

Reply to this Message

Jim Cone - 20 Sep 2007 18:22 GMT

On the menu bar: Insert | Module
-or maybe -
At the bottom of the module widow, next to the
scroll bar are buttons for procedure view and module view.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Randy"
wrote in message
Does anybody know of any ways to organize the VB Editor?
I have quite a few subroutines and my editor is getting pretty long.
In VB.NET, you can create "regions" that allow you to group conceptually
similar subroutines together and then collapse them when you are not
currently working with them. I tried this in VBA, but it didn't work.
Can anybody suggest anything?

Thanks,
Randy

Reply to this Message