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...
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
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!
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***)
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.
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.
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. 👍
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
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🙏
I am learning a lot from your videos in this quarantine. Thank you 🙏🏻.
Great tutorial on VBA functions, especially your last example on extracting values. Thanks
Awesome! Much appreciated 👍
Thank you veryyy muchhh. You are the best!
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
Thanks Brother
Very helpful session
Thank you
Very useful! Thank you
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...
Very informative Video
Awesome stuff.
you are amezing
Great
Thanks so much.
It would be better if you would show to create a help menu also
very useful, thank youu
Thank you so much
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
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!
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***)
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.
Do you also do Power Pivot? PQ + VBA + PP = Excel guru
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.
how can i create function like - if function( (If function(_) ) ?
Very Interesting.
.
Sir,
How can we create Xlookup Function for office 2013 ?
we cannot create i guess
What does the second 1 on (i,1) represent ? Does it reperesent the column number?
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. 👍
@@martinsefelin4479 Thank you Martin
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
The last example doesn´t work
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🙏
its shows an error.