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
-
34:00
The Crypto Report
15 hours agoALTCOIN SEASON BEGINS? (Ethereum Outperforming Bitcoin!) LIVE Crypto News!!!
371 -
2:02:19
Melonie Mac
9 hours agoGo Boom Live Ep 55!
2.4K4 -
1:57:15
Side Scrollers Podcast
18 hours agoZelda Actress NOT a Dude, Darth Vader’s Lightsaber Auction, Evil Elmo Update | Side Scrollers LIVE
72.3K3 -
1:49:58
Omar Elattar
5 days agoLUKE BELMAR: From Broke To $50 Million | Crypto Predictions | Truth About God, Bible & The Matrix
6.25K -
10:17
Dr Disrespect
1 day agoIt's Time To Get Serious
118K17 -
1:56:18
The Michelle Moore Show
18 hours ago'Parasites and Worms...What You Need To Know' Guest, Kim Rogers 'The Worm Queen' The Michelle Moore Show (July 16, 2025)
17K15 -
33:32
Solar Groove Muzic
1 day ago $0.59 earnedSUMMER AFRO HOUSE | Amalfi Coast 2025 (Adam Port, Avicii, The Weeknd, Black Coffee, Diplo)
10.7K -
39:22
The Brett Cooper Show
2 days ago $4.59 earnedBieber’s Big F-You To Hollywood & Trump Gets Ratio’d Over Epstein | Episode 48
11.8K11 -
2:41:02
FreshandFit
7 hours agoFormer Escort vs Trad-Wife HEATED DEBATE
207K79 -
2:04:47
Inverted World Live
9 hours agoDoomsday Clouds and Mega Tsunamis
97.7K8