Create Custom Functions in Excel (User Defined Functions)
HTML-код
- Опубликовано: 8 фев 2025
- Get the Excel VBA Guide for Beginners with extended and revised content here: excelmacroclas...
In this video we see how to create custom functions or user defined functions in Excel using VBA. A function procedure can be added to an standard module as we add sub procedures (or macros). However, the function procedure usually accepts some parameters and always return a value or outcome. Custom functions defined through function procedures are readily available from within any cell in a worksheet in Excel.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclas...
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun....)
Excel Macro Business (excelmacrobusi...)
Excel Macro Sports (excelmacrospor...)
Thank you so much
Is there any we can the suggestion of the custom function in other sheets also?
The custom function can be used in any sheet, and if it's public, even in any workbook if the workbook with the function procedure is open.
Love your videos and easy to learn...can you able to make a VBA for validating sheet1 and sheet 2 as compare with unique numbers from both the sheets and bring out the data only which are not matching with both the sheets and our criteria should be date or quarter
Glad you like it. What you are asking is more related to some other videos, please check those because it may have what you need. I have a mini-series to compare everything in Excel, these 2 are about comparing worksheets:
ruclips.net/video/jyZHOIbHtv8/видео.html
ruclips.net/video/T4QMCoFlVdc/видео.html
Also, I have some older videos to compare two worksheets (this is probably what you are looking): ruclips.net/video/hZIFnKetyI0/видео.html
And to compare 2 workbooks: ruclips.net/video/4lLlX_pXoA0/видео.html
And to compare 2 columns: ruclips.net/video/UvnefIMtNnM/видео.html
@@ExcelMacroMania thanks for your response... comparison is ok after comparing I am looking for reconciliation it's more like comparison two accounting sets...and pull the data where only variences from both the sheets using multiple criteria I know it's too much to ask but am also looking at your videos and learning and taking points on how to ease my tasks....