How To Create Custom Functions In Excel With Vba

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

In this video I explain how to write UDFs (User Defined Functions) for Excel in VBA. UDFs allow us to create custom functions that can be used in formulas. If a function doesn't exist in Excel, then we can write our own to perform calculations.

For this example I show how to create a function that calculates the fiscal year based on a date. There is not fiscal year function built into Excel, so we write our own with VBA.

I also explain the pros and cons of UDFs. It's important you know where to store the code for the UDF, especially when sending files to other users, and I explain everything you need to know in the video.

Additional Resources:

🎦 How to Copy/Import VBA Code To Another Workbook:    • How To Import Or Copy Vba Code To Ano...  

🎦 How to Create a Personal Macro Workbook (playlist):    • The Personal Macro Workbook in Excel ...  

🎦 How to Enable the Developer Tab in Excel:    • How to Enable the Developer Tab in Ex...  

📄 18 Shortcuts for VBA: https://www.excelcampus.com/vba/excel...
00:00 Introduction
00:10 UDFs
00:55 VBA Editor