How to Create UDFs (User Defined Functions) in Excel with VBA

In this video I explain how to write UDFs (User Defined Functions) for Excel in VBA. UDFs allow us to create 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 Create a Personal Macro Workbook (playlist):

🎦 How to Enable the Developer Tab in Excel:

📄 18 Shortcuts for VBA:

excel,excel campus,visual basic for applications,vba tutorial,visual basic for applications excel,user defined function in excel,user defined function in excel vba,vba tutorials for beginners,excel vba user defined function,vba user defined function,excel udf function,excel udf vba,udf vba excel,excel user defined function,excel custom functions vba,how to add custom function in excel,