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

[@reechatimilsina5640]

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

[@yashlimbachiya7327]

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

[@deninsrmic4165]

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

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

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

[@allyshah90]

Thank you veryyy muchhh. You are the best!

[@martinsefelin4479]

Awesome! Much appreciated 👍

[@darrendowson5081]

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!

[@arunkumar-bd9it]

Thanks Brother

[@deepaktambe8043]

Very useful! Thank you

[@JATINKUMAR-qu4vi]

Very helpful session

[@manishkumarchd]

Thank you

[@awesh1986]

Awesome stuff.

[@antoniorasco1928]

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

[@tanjidirfan4833]

Very informative Video

[@aymanebziou2656]

very useful, thank youu

[@ajitkumarsahoo3914]

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.

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@ExcelMadeEasy444]

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

[@yugalgarg71]

we cannot create i guess

[@ravi670100]

you are amezing

[@abhinaygarg7029]

Thank you so much

[@arghyadutta9091]

Great

[@nadermounir8228]

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

[@martinsefelin4479]

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]

@@martinsefelin4479 Thank you Martin

[@harshil6920]

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

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

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

[@vba_appsscript]

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

[@nadermounir8228]

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

[@Angel_Heart2009]

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🙏

[@nachoo6290]

The last example doesn´t work

[@rakibhasan1425]

its shows an error.