In the code window, type the code of Age User Defined Function Step 2: Enter the code of User Defined Function You will also see the module appear in the Project Explorer panel. This adds a new empty code module to the selected workbook. If the Project Explorer is not visible, open it by going to View > Project Explorer.įrom the Insert menu choose Module. In Visual Basic Editor, select VBAProject in the Project Explorer panel. Open the Visual Basic Editor from Developer tab, Go to Developer tab.Ĭlick on Visual Basic (Keys: ALT+F11), it will open Visual Basic Editor. Start Excel or, if you already have Excel open, create a new empty workbook.

Step 1: Add a code module to a new workbook This article shows you how to write a custom function using Excel VBA, and how to save and install it as an Add-In.Ĭustom functions are often referred to as UDFs (User Defined Functions).Īn Add-In can contain as many UDFs (User Defined Functions) as you want, and you can add more lately, simply by opening and editing the Add-In file. Excel is shipped with a variety of Add-Ins ready for you to load and start using, and many third-party Add-Ins are also available. The file contains VBA code that adds additional functionality to Excel, usually in the form of new functions.Īdd-Ins provide an excellent way of increasing the power of Excel and they are the ideal vehicle for distributing your custom functions. xlam extension) that Excel can load when it starts up. An Excel Add-In is a file (usually with an.

Excel add ins how to