Premium Only Content

Excel VBA FIND Function (& how to handle if value NOT found)
July 12, 2018 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
Quickly learn how to use the VBA FIND Function. What parameters are required. How to look for partial matches or for complete matches (whole word). Also if VBA should search in the cells, formulas or comments. I also show you how to handle cases if VBA FIND doesn't find a value. So in cases where your text or value is not found.
You'll want to account for this, because in case your text or value is not found, you'll get a VBA error. In order to avoid the error, you can use the VBA IF statement. This ensures that if a value is not found, you will not end up with an error, instead you can decide what you'd like to do (in the video I'll show you how to create a custom message box, informing the user that the value was not found).
★ Links to related videos: ★
Check out the full playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ My Online Excel Courses ★
Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #ExcelVBA #LeilaGharani
-
LIVE
Dr Disrespect
5 hours ago🔴LIVE - DR DISRESPECT - WARZONE - RAGE ON THE MAIN STAGE
2,235 watching -
LIVE
Candace Show Podcast
48 minutes agoEXCLUSIVE! Brigitte Macron's Lawyer Has A Dark Past. Dan Bongino Speaks Out. | Candace Ep 220
2,397 watching -
1:18:11
Redacted News
36 minutes agoScotland is being DESTROYED and Neil Oliver is trying to save it
3 -
1:11:04
vivafrei
2 hours agoWhat Did Bongino See? The Epstein "Privilege"! Canada Has Become a Dangerous JOKE & MORE!
16.9K38 -
2:07:48
The Quartering
4 hours agoToday's Breaking News With Josie The Red Headed Libertarian, Hannah Claire & Luke Rodkowski
92.4K22 -
LIVE
Akademiks
3 hours agoDrake Tries for another #1?? Kodak vs YB still? Ksoo gets snitched on. Doechii plz stop botting
1,160 watching -
LIVE
The HotSeat
57 minutes agoHate Crimes In Cincy + Hiring A White Girl Makes You A NAZI?!?!
641 watching -
25:24
Stephen Gardner
1 hour ago🔥 RFK Just SHUT DOWN a DISTURBING Problem!
2965 -
LIVE
Film Threat
6 hours agoVERSUS: SUPERMAN VS. THE FANTASTIC FOUR | Film Threat Versus
133 watching -
LIVE
The Nunn Report - w/ Dan Nunn
1 hour ago[Ep 715] The Trump Way: Deals & Peace | Hate Crimes – Brutal Beat Downs | CA Homeless Money Scam
236 watching