Custom Functions (UDF)
Write your own worksheet functions in VBA and use them in cells just like SUM or VLOOKUP.
The first lesson is free — no account needed.
About this course
Write your own worksheet functions in VBA and use them in cells just like SUM or VLOOKUP. You learn how a Function differs from a Sub, write your first Excel UDF, handle arguments, types and error values, use Optional and ParamArray, return more than one value, and understand volatility, speed limits and sharing your UDFs.
Lessons
- Function vs Sub: What Actually DiffersFree
- Your First Worksheet Function Pro
- Arguments, Types and Error Values Pro
- Optional Arguments and ParamArray Pro
- Returning More Than One Value Pro
- Volatile Functions and Recalculation Pro
- Why UDFs Can Be Slow — and What They Cannot Do Pro
- Sharing, Debugging and Living With Your UDFs Pro