Using Find and FindNext Functions in VBA

How to use the Find and FindNext methods in VBA to search for data in an Excel worksheet quickly and easily. More details available at this link:

[technews]

very helping and useful video.. i was searching this since many times.... thanks

[tarekererajeeva]

Sir in in salary column suppose we have numbers say 1, 2, 15, 1, 16, 31 and if I search for number 1 it is showing all columns except column having number 2. Please guide me sir

[SRHarkreader]

Once again, you delivered a valuable lesson with a perfect blend of articulation, precision and pithiness at a slow pace that can be increased, using YouTube's control, to suit our individual preference; great job!

[naimsaid]

hi i have found list in column (A) of name this name is repeated several times, I am looking for a code that I fill cell in column (B) with first found if is empty is only once for second time I fill second empty cell these values by textbox

[GhostRider-mzhl]

I have tried your vba code to find the next empty cell on my workbooks but! it does not work, because my workbooks I am working on all have a combination of formatted and conditional formatting in my cells as well as I have a clear button set up to clear the contents in the range, also the copied area (range) in my workbook/sheet has formulas built in the cells, the paste option in my vba code is PasteSpecial xlPasteValues, I am using microsoft office 365 subscription, so please at your earliest convenience let me know the solution, thank you, happy new year. Ps forgot to mention the error message I get is Application-defined or object-defined error or Subscript out of range (Error 9)

[drcv]

Thank you very much sir. It's a great learning to me.

[adamkamal]

Dear Dinesh Kumar Takyar, Thank you for your great assistant and support, sir my listbox shows 2 column (customer name & customer payment) and both of them based on invoice sheet - I want to select more than 1 customer from my listbox which is built on userform (MultiSelect) and calculate the total payment for each of them using sumifs function (on the basis of the customer name column in my listbox) then display the result for each customer in the same msgbox in succession. Can you advice on the vba code to set this condition? Thanks alot in advance

[Akbar-uxbc]

Very useful video tutorial. Sir, Is it possible to give me your email? I did finding matches on VBA And i have done almost 90% but there is a little problem with putting colors. Thank you.

[nandakumar]

Hello sir
This helps me to save 25% of work time
I'll u pls let me know how to get the refence number to put on "D collum" instead of a message box

2nd thing is the is it possible to find multiple duplicate data, put the reference number in D cell as well as, instead of one specific data can u pls help to find multiple duplicates

[WTG]

thanks you for this video sir. I tried requesting the value of firstaddress with : firstaddress.address or firstaddress.value in the immediate window and I get an error saying object required. why is this?

[shadow_gaming_sk]

Dear sir I have the sales data like categeory wise customer wise invoice date wise week wise sales value

I required out put is to find out the new customers billed in week 2 comparitive last week ie week these customers not billed in week 1 .

[clamgoh]

Hi can you show us how to write the VBA to find column B valve > than for example > than 10000

[hanish]

Hi Sir,
Thanks for the lesson. its really valuable, i just have one query here, if i have a item in column A and a blend of string in column B . How can i extract specific data from that string corresponding to item in column A and save it in sheet2

[irawansa]

Thanks Dinesh!... It was very useful for my project(JAKARTA, INDONESIA)

[derickcoley]

Hi Dinesh, thank you so much for presenting this solution, I had been struggling to get the find next working in my Visual Studio application but this example works perfectly, again thank you for sharing

[yannfontaine]

Hi,
Thank you very much for this tutorial, which is very well explained
I have a question: how would you modify the code to display "John" and "Harry" instead of "B2" and "B5" please ?

[robertlohman]

Great video.  Why did you not declare firstaddress

[prabhugbhopal]

Hello sir I want to make download and upload file button option for any type file such as PDF Docs and Jpeg in excel seet.
please give me solution.

[aussteeladmin]

Hi ive been watching and learning alot from your videos. However on this particle one ive created a Workbook that has 3 Sheets on them. my code breaks down immediately after Set oWkSht=Sheets("Sheet3"). The error I get is that the subscript is out of range. Under Excel Objects, the Sheet3 (Order Registry) is the name. Ive tried changing the "Sheet3" to Order Registry but I think ive done something wrong somewhere. can you please advise. thank you

[krn]

Thanks Dinesh. Little quieter this time. Good traffic day I guess. Lol