"You name the thing and it will be there",Yes it is definitely true. Your channel is like a hidden treasure.Thanks for providing such an expert level guidance on VBA.
Hi Ajay as I mentioned in my last comment that I am facing V lookup error challenge so I thought before sending you an email lets check it out in your existing series if it would not there then I will definitely mark you an email so finally got my answer thank you so much really great efforts.
thats a great news if other video helped you. Thank you for being so consistent in liking my stuff and appreciating always...i need you to bring more people on channel before i go and close the channel due to so less subsribers :(. kindly help prakash
Hi Ajay Sir, i have just start learning Vlookup in VBA . i have look all your videos on Vlookup but i just wanr to knw if i want to lookup from some other excel file of different location without open it please help with this waiting for your reply thanks
how to do same using do while loop??? for me when am using resume next on error handler :1004, within do while loop its still pulling previous value insted name not found
Please i have a data that has some cell content together with comments. I want to do a Vlookup to get the cell content togther with the comments in that cell. Kindly help out sir
Private Sub ComboBox1_Change() If Me.ComboBox1.Value "" Then Me.TextBox1.Value = Application.WorksheetFunction.VLookup(CLng(Me.ComboBox1.Value), ThisWorkbook.Sheets("Monthly Summary").Range("A:B"), 2, 0)
"You name the thing and it will be there",Yes it is definitely true.
Your channel is like a hidden treasure.Thanks for providing such an expert level guidance on VBA.
Indeed, such a big compliment for me. You make me the best... I am just doing little.thank you for your support dear
Cheers..
You are d real hero.. Teaching all of us for free of cost.. Thank so much vba guru.. I have learned a lot from ur videos
From Every house we need a programmer
Your example and explanation is very easy to understand, thank you very much.
very useful sir 👍👍👍👍👍👍
Hi Ajay as I mentioned in my last comment that I am facing V lookup error challenge so I thought before sending you an email lets check it out in your existing series if it would not there then I will definitely mark you an email so finally got my answer thank you so much really great efforts.
thats a great news if other video helped you. Thank you for being so consistent in liking my stuff and appreciating always...i need you to bring more people on channel before i go and close the channel due to so less subsribers :(. kindly help prakash
Ajay Kumar definitely I will.
Dear Sir your teaching method is awesome. You are great sir.
Thanks very much... Keep coming here and commenting...
Awesome sir.. on error resume next.. go to.. exit sub....wow
Very well explained. Thank you!
Thank you Sir
your videos are awesome. Keep up the good work :)
thank you Vivek...feel like home here...keep posting..
Hi Ajay Sir,
i have just start learning Vlookup in VBA .
i have look all your videos on Vlookup but i just wanr to knw if i want to lookup from some other excel file of different location without open it
please help with this
waiting for your reply
thanks
thank you..
You're most welcome
can't we use only IF condition here instead of using IF Else because there is nothing in else statement ?
U can avoid it..
thanks
how to do same using do while loop???
for me when am using resume next on error handler :1004, within do while loop its still pulling previous value insted name not found
Use on error goto then... see video on it under Excel Vba introduction playlist
Ajay Kumar thank you... you rock!!!
I found first ever vba tutorial with lots of ample information.. thanks again... great job!!!
Thanks Jay. Rise n shine. Please bring more people on channel and let us rise together
I am getting the 1004 error even when the lookup value is present in lookup range...
Please i have a data that has some cell content together with comments. I want to do a Vlookup to get the cell content togther with the comments in that cell. Kindly help out sir
Use star wild card in vlookup
@@AjayKumarparmar Thank you sir
Private Sub ComboBox1_Change()
If Me.ComboBox1.Value "" Then
Me.TextBox1.Value = Application.WorksheetFunction.VLookup(CLng(Me.ComboBox1.Value), ThisWorkbook.Sheets("Monthly Summary").Range("A:B"), 2, 0)
Else
Me.TextBox1.Value = ""
End If
End Sub
how solve run time error 13 on this one
Which line is an issue
Very well explained. Thank you!