Supercharge Excel: Build Your Custom Function Library in Minutes!

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders/
File Reference for this video: 0242 Function Library.zip

Unfortunately, YouTube does not allow me to paste all the code in here because it includes some special characters that are not allowed. To get the code, download the example file.


★ About this video ★
As we've looked at LAMBDA custom functions, a consistent question has come up: "How can we make these available for all of our workbooks?" And the answer is we can't. We need the workbook to calculate no matter who sees it. Therefore, that custom function has to exist in that workbook.

However, in this video, we look at how to build a library for our custom functions so we can easily insert them into any workbook.

0:00 Introduction
0:33 Personal Macro Workbook
1:44 The VBA Code
2:41 Create the buttons
4:40 Add functions to the library
5:58 Using the library
6:46 Editing the library
12:14 Wrap-up


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel