Creating Excel VBA Add-Ins

poleary2000

Active Member
Joined
Apr 1, 2002
Messages
354
All,

This forum is great! I have been able to vastly increase by knowledge of VBA through asking questions and reading other posts.

From this board, I have obtained a bunch of useful snippets of code that do some really cool things. Is there a way I can create an add-in that would allow me to use these tools in any workbook? Sort of like PUP. I use a lot of these tools quite often and would like to find a way to use them easily.

Suggestions anyone?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

poleary2000

Active Member
Joined
Apr 1, 2002
Messages
354
So...the easiest way is to create an Excel Workbook that has modules containing the code I would like to reference. Then, create a toolbar that would link to the code.

Then, save the workbook as .xla. Put it in the startup folder and I should be good right?

Patrick
 

Jim North

MrExcel MVP
Joined
Jun 20, 2002
Messages
791

ADVERTISEMENT

... and if this is for your personal use only, you could store it in your personal.xls... it is a "reserved" workbook in Excel.
 

poleary2000

Active Member
Joined
Apr 1, 2002
Messages
354

ADVERTISEMENT

Compile my VBA code?
 

Jim North

MrExcel MVP
Joined
Jun 20, 2002
Messages
791
compiling VBA... when you are in VBE (visual basic editor) click on DEBUG... the first item on the drop down menu is COMPILE.

Regarding PERSONAL.XLS, it is a "hidden" workbook that Excel reserves for you. It's intent is for you to store common macros. One place you can see it is when you record a macro... it asks "Store macro in"... one of the options is Personal Macro Workbook.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,499
Messages
5,596,517
Members
414,074
Latest member
Matthew Kakde

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top