Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort subs
I have a workbook with several modules and many subs and functions within
each module. What is the easiest way to get the Visual Basic Editor to sort the macros within each module to put them in alphbetic order? -- Gary's Student |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort subs
There is no simple way to do this. And it begs the question, why
do it? The procedures are listed alphabetically in the right-side dropdown at the top of the code window. You can select a proc there and the VBE will go directly to that proc. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Gary''s Student" wrote in message ... I have a workbook with several modules and many subs and functions within each module. What is the easiest way to get the Visual Basic Editor to sort the macros within each module to put them in alphbetic order? -- Gary's Student |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort subs
And on top of what Chip wrote...
There's a couple of buttons on the bottom of the code window. (These buttons are to the left of the bottom scroll bar.) If you let your cursor linger over each of them, you'll see: "Procedure view" and "Full Module view". If you go into procedure view, you won't even know about the other procedures. (Well, you can still pageup/pagedown through them--but they're almost invisible(?).) Gary''s Student wrote: I have a workbook with several modules and many subs and functions within each module. What is the easiest way to get the Visual Basic Editor to sort the macros within each module to put them in alphbetic order? -- Gary's Student -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort subs
Thank you both very much. I now see that by using only a single module, I
can get much better visibility and access to the pile o'sutff that I have collected. -- Gary''s Student "Dave Peterson" wrote: And on top of what Chip wrote... There's a couple of buttons on the bottom of the code window. (These buttons are to the left of the bottom scroll bar.) If you let your cursor linger over each of them, you'll see: "Procedure view" and "Full Module view". If you go into procedure view, you won't even know about the other procedures. (Well, you can still pageup/pagedown through them--but they're almost invisible(?).) Gary''s Student wrote: I have a workbook with several modules and many subs and functions within each module. What is the easiest way to get the Visual Basic Editor to sort the macros within each module to put them in alphbetic order? -- Gary's Student -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort subs. by amount | Excel Discussion (Misc queries) | |||
Scope of Subs? | Excel Programming | |||
Private subs | Excel Programming | |||
Stringing Subs | Excel Programming | |||
calling subs | Excel Programming |