We have over 100 macros in our worksheet. We would like to sort the macros in the vb editor so that they are in alphabetical order.
Thanks
We have over 100 macros in our worksheet. We would like to sort the macros in the vb editor so that they are in alphabetical order.
Thanks
I thought they were automatically arranged alphabetically?
Ah, are you talking about macros in the same module?
The drop down box for selecting the macro to edit has the macros in alphabetical order. The macros where you code are in the order they were created. I would like to be able to scroll through the macro code itself in order of the macro name.
Sub First_Created() MsgBox "This is the first sub ever created" End Sub Sub AAA() msgbox " I would like the sub AAA to be listed in the coding window before sub first created" End Sub Sub BBB() msgbox "Alphabetically sub bbb should be after sub AAA and before sub first _created in the coding window" end sub
What I am trying to do is sort the macros so they appear in the editor in order of macro name.
I don't know how to do that, but one workaround would be to put only one macro in each module, and name the module the same as the macro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks