Free Excel VBA Course #20 - Creating Custom Functions in Excel Using VBA

In this video, I will show you how to create custom functions in Excel using VBA.

You can use these custom functions just like regular functions. In VBA, you can program these to perform calculations and then return the desired value.

This is a great way to use VBA to enhance Excel's capability as you can create a function and do stuff ṭhat you can not do with regular Excel functions.

#Excel #ExcelTips #ExcelTutorial

[reechatimilsina]

I am learning a lot from your videos in this quarantine. Thank you 🙏🏻.

[deninsrmic]

Great tutorial on VBA functions, especially your last example on extracting values. Thanks

[trainingforcarlos]

Hello, Thanks a lot for all your videos.
I really enjoyed the custom function, it is exactly what I needed to make some tasks of my job faster. Thanks a Lot...

[allyshah]

Thank you veryyy muchhh. You are the best!

[yashlimbachiya]

Hey trump excel, I love your videos and I am becoming good in excel I have a doubt that can we use select case statement in creating custom function

[avimunde]

Dear Sumit Sir, Thanks for providing this type of custom function, this was very helpful while working on Excel and VBA, I am having one problem while writing the function, how to do the sum of value for particular variable in lookup range

[ajitkumarsahoo]

Please guide.
A value is pasted in a cell within a range with VLOOKUP formula and the value so obtained is formatted into Date format. System converts the zero value into 00-01-1900 format. What is the VBA code to change the 00-01-1900 date value to text within the range without formatting other date values.

[darrendowson]

A question if I may.

Function inputMonth is declared as an integer, and the inputdate argument is declared as a Date.
Then, SingleCellExtract, the arguments are declared but function SingleCellExtract is not. Is this because of SingleCellExtract then being equal to 'result', which in itself is declared as a string?

Great videos, thanks, coffee shall be on its way!

[nadermounir]

What does the second 1 on (i, 1) represent ? Does it reperesent the column number?

[vba_appsscript]

It would be better if you would show to create a help menu also

[antoniorasco]

Do you also do Power Pivot? PQ + VBA + PP = Excel guru

[nadermounir]

Adding the space after result then added a comma after the column number? Shouldn't we put the space also at the end like we did for the comma? This part is confusing

[harshil]

how can i create function like - if function( (If function(_) ) ?

[ExcelMadeEasy]

Very Interesting.
.
Sir,
How can we create Xlookup Function for office 2013 ?

[deexcelguy]

Hi Sumit Bansal,
Just want to say you have a fantastic course... but I want to point out something about your code... though it works It was not necessary... to add the space before

Check the video 14.40

Here is your code
If Lookuprange.Cells(i, 1) = Lookupvalue then
Result= Result & " " & Lookuprange.Cells(i, ColumnNumber) & ", "
End If

Here is my code
If Lookuprange.Cells(i, 1) = Lookupvalue then
Result = Result & Lookuprange.Cells(i, ColumnNumber) & ", "
End If

This works better because yours add some extra space at the beginning...
Just my humble contribution to your great course.

Kindly,
Ferdinand Nrele Attobra (***DeExcelGuy***)

[Angel_Heart]

Thank you sir can you please help me more examples and give me assignment for self practice...sir I want online vba class so how can I reach you plz reply to my msg🙏