Create Custom Functions in Excel (User Defined Functions)

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

[@MohAboAbdo]

Thank you so much

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

[@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: kzbin.info/www/bejne/oKq9eYJ_l62nrJo kzbin.info/www/bejne/imW0fnale9GJmsU Also, I have some older videos to compare two worksheets (this is probably what you are looking): kzbin.info/www/bejne/nousd6GBmtmsf5I And to compare 2 workbooks: kzbin.info/www/bejne/ap2vnYuVpb2id5I And to compare 2 columns: kzbin.info/www/bejne/i6fRlpl_gtmBpK8

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