PDA

View Full Version : sorting the project explorer



lior03
04-29-2006, 09:02 AM
hello
during the course of learning vba i came across a
lot of material.the name of my vba modules became something like module 1 module 11 module 111 and so on.is it possible to sort them by name?
thanks

XLGibbs
04-29-2006, 10:30 AM
YOu can manually sort them by clicking and holding them and dragging them up and down. In the module properties you can rename them from module1 to whatever you choose by changing the modules name property.

Emily
04-30-2006, 09:57 AM
There is a Sort Procedure in MZ-Tools VBE Add-in
http://www.mztools.com/v3/download.htm

TonyJollans
04-30-2006, 02:35 PM
Contrary to what the other posters have said, you cannot sort (or rather unsort) VBA modules in the Project Explorer. The Projects are displayed in alphabetic order and the modules within each are in alphabetic order. If you have Folders showing they are in a predefined order within the project and modules within them are, again, in alphabetic order.

You can, if you want, name your modules according to some naming standard which would result in any specific order you want.