Excel VBA Find Function - In-Depth Tutorial with Examples

In this video, we take a dive into the Find function of Excel VBA.
Master Excel VBA with this comprehensive online course - bit.ly/2JvnnRv
I'm sure it is no surprise that the Find function can be used to find a value in a list. It then returns the cell that the value was found in.
Once you have the cell from this VBA lookup function, you can perform actions on or from this cell.
The video demonstrates various examples of the application of the Find function.
It also includes examples of some of the more useful options that we can use to refine our search criteria.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@DipankaraBuddhist]

This is the best video about FIND function on the KZbin. Many thanks to you Mr. Alan.

[@Computergaga]

My pleasure. Thanks, Bhuvanesh.

[@michalroesler]

Yes, yes, yes. I've finally found it. The best VBA .find function tutorial on youtube. Thank you Alan. You're the best.

[@Computergaga]

You're welcome. Thank you, Michal.

[@sasavienne]

This time, I decided to like this video before watching it, because I am sure that all your tutorials are more than amazing. 🌟 🌟 🌟 🌟 🌟

[@Computergaga]

Thank you Salim.

[@sasavienne]

All thanks to you Alan.

[@sasavienne]

What you are presenting is useful and stunning. Thank you. 👍

[@Computergaga]

My pleasure.

[@Nutflash1978]

Love your no nonsense teaching style geez, subscribed!

[@Computergaga]

Thank you Dobbin.

[@wayneedmondson1065]

Hi Alan.. great video on the VBA Find function and its various uses. I especially like your advice about clearing Application.FindFormat and or any of the Find arguments after running the routine. I learned that the hard way.. haha!! Always a pleasure to watch your videos and learn from your straight to the point and no nonsense style of instruction. I also appreciate and enjoy your interspersed wit and humor. Thumbs up!!

[@Computergaga]

Thank you Wayne. Your comments are much appreciated.

[@zipperman4558]

Thank you 🙏. It was very well explained in detail.

[@Computergaga]

Thank you very much.

[@beenay18]

what does searchdirection:=xlprevious does?

[@eason777662893]

I want to know how I can create a Textbox to put the cursor next to the found item so I can manually input the count. For example, if I have a list of names on column A and respective barcodes on column B, how can I scan the barcode into the Textbook so excel can automatically place the cursor in the desired box for me to type in a number? Thank you so much for any help.

[@semperdiscendum7439]

Great! Thank you!! 👍👍

[@Computergaga]

You're very welcome Shashikant.

[@alializadeh8195]

Thanx

[@Computergaga]

Thank you, Ali.

[@petersoncpxb]

Can I use it with IF to find a file to attach in an email.

[@qrnasr246]

Amazing

[@Computergaga]

Thank you Qr Nasr.

[@zkz900]

Excel Vedran Bađun Adventures