HDTutorial
EN
How to Create Custom Functions (UDFs) in Excel with VBA

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create Custom Functions (UDFs) in Excel with VBA

79,836 views October 26, 2019 15:15

Watch on YouTube
ChannelExcel Campus - Jon

Chapters

Description from the creator

Sign up for our Excel webinar, times added weekly: 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: youtube.com/watch?v=ett0WiTfQuI

🎦 How to Create a Personal Macro Workbook (playlist): youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzM…

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

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

About this tutorial

Excel Campus - Jon published this 15:15 video tutorial on October 26, 2019. It has been watched 79,836 times on YouTube.

Category
Education
Duration
15:15
Published
October 26, 2019
Views
79,836
Likes
634

Tags

Share

Further reading

This tutorial in other languages