PDA

View Full Version : Bunch of Macros in One Item.



Rakesh
05-02-2015, 02:55 AM
Hi Rocks,

I had more than 20 VBA macros. Every Time I have to add it through Template and Add-ins.
Can it Possible to get all in One, Something to choose from Userform or combobox or List Box or Menu Item (i.e., to select a Macro from a bunch of List and Sublist)

Attached file for your reference.

Thanks in advance
Rakesh.

gmayor
05-02-2015, 03:56 AM
What do all these macros do, and how do they relate to your document?
Macros saved in a template in the startup folder, load with Word, so you don't need to load them each time.
If you have not changed the preferred startup folder it can be located (in English language versions of Windows) by typing
%appdata%\Microsoft\Word\Startup
in the Windows Explorer Address bar and pressing Enter.
Maybe http://gregmaxey.mvps.org/word_tip_pages/populate_userform_listbox_or_combobox.html is what you had in mind?