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

Рет қаралды 25,772

Күн бұрын

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.
✅ Download File: bit.ly/vbacourse-20
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 34

@reechatimilsina5640 4 жыл бұрын

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

@deninsrmic4165 Жыл бұрын

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

@trainingforcarlos 4 жыл бұрын

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

@martinsefelin4479 3 жыл бұрын

Awesome! Much appreciated 👍

@deepaktambe8043 3 жыл бұрын

Very useful! Thank you

@yashlimbachiya7327 4 жыл бұрын

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

@allyshah90 Жыл бұрын

Thank you veryyy muchhh. You are the best!

@awesh1986 3 жыл бұрын

Awesome stuff.

@avimunde 3 жыл бұрын

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

@aymanebziou2656 3 жыл бұрын

very useful, thank youu

@JATINKUMAR-qu4vi 2 жыл бұрын

Very helpful session

@tanjidirfan4833 3 жыл бұрын

Very informative Video

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@abhinaygarg7029 3 жыл бұрын

Thank you so much

@manishkumarchd 3 жыл бұрын

Thank you

@arunkumar-bd9it 3 жыл бұрын

Thanks Brother

@ravi670100 2 жыл бұрын

you are amezing

@arghyadutta9091 Жыл бұрын

Great

@darrendowson5081 3 жыл бұрын

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!

@vba_appsscript Жыл бұрын

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

@antoniorasco1928 4 жыл бұрын

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

@nadermounir8228 4 жыл бұрын

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

@martinsefelin4479 3 жыл бұрын

Yep, you got it right. Since ”i” is the loop variable it will be i +1 in next iteration. This is how it will move by one row and not by column. Hope this makes it clear. 👍

@nadermounir8228 3 жыл бұрын

@@martinsefelin4479 Thank you Martin

@ajitkumarsahoo3914 2 жыл бұрын

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.

@ExcelMadeEasy444 4 жыл бұрын

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

@yugalgarg71 4 жыл бұрын

we cannot create i guess

@harshil6920 Жыл бұрын

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

@nadermounir8228 4 жыл бұрын

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

@deexcelguy 4 жыл бұрын

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

@saywot9688 Жыл бұрын

I would leave it alone until the last line of code, then change it to: SingleCellExtract = Trim(left(Result , Len(Result) - 1)) to get rid of BOTH trailing comma and leading space.

@nachoo6290 3 жыл бұрын

The last example doesn´t work

@Angel_Heart2009 8 ай бұрын

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🙏