VBA macros library

[-Citizen]

Hi!

For us who are not frequent users of macros, but do so from time to time, it can be a little bit challenging to remember stuff. To be honest, if I have not used it in some months, I even forget how to write the start of the code

So, my question is basically the following, is it possible to create a library with macros that you can easy access when excel is open (without opening any sheets)? I am basically thinking of a library with modules where you can sort different codes and such. Is this possible to create?

Then my second question, if this is possible to create, are there any good libraries out there that you can use? Or do you create everything from scratch?


Thanks in advance

[6StringJazzer]

I put all of my general-purpose macros in the file PERSONAL.xlsb. This file is created by default in the Excel Startup folder, and so is opened every time you open Excel. It defaults to be hidden. If you go to your macro project navigator (ALT+F11) you should see it on the left as the first file.

I am not aware of any libraries of general-purpose code you can download. There are some packages that are available as add-ins, though many that I've seen are commercial products with protected code.

[TMS]

What do you want a library of codes to do?

When I was developing code for clients, each workbook needed to be free standing so, in all honesty, I’ve never used a library. For me, there was no point calling on a routine in a PERSONAL.xlsb, because it wouldn't be available when I handed over the workbook to the client.

The easy way, for me, was to create an .xlsm workbook and have specific named modules for specific functions, or groups of functions. For example, you might have functions to get the first row, last row, first column, last column, number of rows, number of columns, whatever. Then, when you need a specific function in a workbook, just copy and paste it from your "memory book".

All that said, I code most things from scratch and, if I can't remember something, I’ll record a macro to get the basic structure and then adapt it.

Chances are, if you just copy and paste stuff, you'll never commit the basics to memory.

[Artik]

Many tools that make it easier to build code include predefined code libraries, or at least allow you to save snippets for re-creation. I use two such tools: Code VBA and MZ-Tools. The code library itself can be opened outside of Office: Total Visual SourceBook. All of these are paid tools, of course.
But I can provide a demo version of an add-in of my own making for saving code snippets. It is possible to save snippets in five groups, 10 snippets in each group. Each snippet can be edited or deleted at any time. So you have the possibility to save up to 50 snippets.
After downloading, the zip file needs to be unzipped. In the file manager, call up the pop-up menu from under the right click, select Properties and remove the lock (if it exists). Only then can the add-in be installed in Excel.
In the VBA editor, an "Insert Fragment" icon will appear at the beginning of the Edit toolbar to call the tool.


Artik

[-Citizen]

Thanks for all the answers!

TMS, I see your point, no doubt about it, but as you wrote "making a code for a client", means that you probably do a lot of coding. I am an engineer and I use macros from time to time, but not often enough to remember stuff. That's why I kinda need a little "help" getting there

Artik, thanks for the file, the file requires a password (when opening in excel VBA), do you have the password available?

[Artik]

The provided add-in does not require a password to work with it. But it is an add-in for work, not for learning, so I do not anticipate making the password for the project public.
If 50 excerpts are not enough, you can always save a few/more than a dozen excerpts in one entry. After pasting into the code, remove the fragments that are unnecessary at the time.

Artik

[-Citizen]

The provided add-in does not require a password to work with it. But it is an add-in for work, not for learning, so I do not anticipate making the password for the project public.
If 50 excerpts are not enough, you can always save a few/more than a dozen excerpts in one entry. After pasting into the code, remove the fragments that are unnecessary at the time.

Artik

Thanks, now I understand how it works.

I can see that it is completely blank, so I will have to make every fragment myself, is this correct?

[Artik]

It is empty, because it is thus tailored to the level of knowledge and needs of each user.

Artik