Excel VBA Find Function - In-Depth Tutorial with Examples

preview_player
Показать описание
In this video, we take a dive into the Find function of Excel VBA.

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;

*** Online Excel Courses ***

Connect with us!

Рекомендации по теме
Комментарии
Автор

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

DipankaraBuddhist
Автор

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

michalroesler
Автор

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

zipperman
Автор

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

sasavienne
Автор

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

sasavienne
Автор

Love your no nonsense teaching style geez, subscribed!

Nutflash
Автор

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!!

wayneedmondson
Автор

what does searchdirection:=xlprevious does?

beenay
Автор

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.

eason
Автор

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

petersoncpxb
welcome to shbcf.ru