Create Custom Functions in Excel (User Defined Functions)

Get the Excel VBA Guide for Beginners with extended and revised content here: excelmacroclass.blogspot.com/...
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: excelmacroclass.blogspot.com/
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.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)

[@MohAboAbdo]

Thank you so much

[@saichandu5965]

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

[@ExcelMacroMania]

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

[@saichandu5965]

@@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....

[@aiswaryasanthosh7878]

Is there any we can the suggestion of the custom function in other sheets also?

[@ExcelMacroMania]

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.