1
One place for codeSave functions once in PERSONAL.XLSB and call them later like normal worksheet formulas.
←
Tools
PERSONAL.XLSB
PERSONAL.XLSB
Personal macro workbook as a function library
PERSONAL.XLSB loads automatically with Excel. This lets you keep custom VBA functions in one place and use them in many files without copying code into every workbook.
2
Good for technical dataIt helps most with part descriptions, standards, dimensions, ERP exports and text cleanup.
3
No LET and no test filesThe example shows the result in a quasi Excel view, but here you download a VBA module, not a ready XLSX.
How to add a function to PERSONAL.XLSB
1
Open Excel and press Alt + F11.
2
Find the PERSONAL.XLSB project. If it is missing, record a short macro and choose the personal macro workbook as the target.
3
Insert a module via Insert → Module or import the downloaded .bas file.
4
Paste the function code, save PERSONAL.XLSB and restart Excel if the function is not visible immediately.
Function idea
Category:
Formula
Example
Below is a quasi Excel view in the course style. Column A contains the input data, column B shows the function result.
VBA for PERSONAL.XLSB
The VBA code is shared and kept in English. Paste it into a VBA module or download the .bas file and import it into the PERSONAL.XLSB project.
Choose a PERSONAL.XLSB example
Choose a VBA function. Names and descriptions follow the current language, while the VBA code stays shared.