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

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: https://www.youtube.com/watch?v=ett0WiTfQuI

How to Create a Personal Macro Workbook (playlist): https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

How to Enable the Developer Tab in Excel: https://youtu.be/JLQ8OuW0FlY

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