View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Organizing the VBE


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.
--
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