Excel VBA FIND Function (& how to handle if value NOT found)
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!
#ExcelVBA
Видео Excel VBA FIND Function (& how to handle if value NOT found) канала Leila Gharani
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!
#ExcelVBA
Видео Excel VBA FIND Function (& how to handle if value NOT found) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel VBA Introduction Part 15a - Find and FindNextEAF #37 - Excel VBA Loop to Find Records Matching Search CriteriaExcel DGET Function Solves 2 of Your VLOOKUP ProblemsExcel VBA IF THEN Statement (with ELSEIF & Looping in cells)Using Find and FindNext Functions in VBAReturn Multiple Match Results in Excel (2 methods)Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)Searchable Drop Down List in Excel (Very Easy with FILTER Function)How to use Excel Index Match (the right way)How to use VBA to search for a value on a WorksheetExcel VBA Arrays: Practical Example of a 2 dimensional array to create a New WorkbookVBA Advanced Filter - The FASTEST way to Copy and Filter DataSURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)Excel IF Function with PARTIAL Text Match (IF with Wildcards)VBA to BROWSE & COPY Data from SELECTED File in ExcelVLOOKUP() Using Macros in Excel - Worksheet Functions for VBAEAF#78 - Use an Excel VBA Loop to search a datatable and copy selected rows to another sheet