Wise Owl Answers - Why Do We Write If Not Is Nothing in Excel VBA?
Check out our other answers here https://youtube.com/playlist?list=PLNIs-AWhQzcluqE43JKakRKslaYwCouJu
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to write a variety of logical tests using If statements in Excel VBA. You'll learn the long and short versions of testing if something is True or False and the difference between testing a value and a reference to an object. You'll see how to use the Is keyword and the Not keyword and understand why we sometimes write the pattern "If Not ... Is Nothing Then".
Chapters
00:00 The Question
01:16 Writing Basic Logical Statements
02:51 Writing Logical Tests in If Statements
04:55 Asking If a Logical Test Returns False
06:44 Using the Not Operator
08:08 Returning Boolean Values from Functions
09:52 Using Boolean Functions in an If Statement
11:10 Testing If a Boolean Function Returns False
12:52 Comparing Objects or Reference Types in VBA
15:57 Comparing Objects using Not Is Syntax
18:07 Testing If a Reference Type Is Nothing
20:53 Testing If a Reference Type Is Not Nothing
22:02 Testing the Result of Application.Intersect
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Видео Wise Owl Answers - Why Do We Write If Not Is Nothing in Excel VBA? канала WiseOwlTutorials
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to write a variety of logical tests using If statements in Excel VBA. You'll learn the long and short versions of testing if something is True or False and the difference between testing a value and a reference to an object. You'll see how to use the Is keyword and the Not keyword and understand why we sometimes write the pattern "If Not ... Is Nothing Then".
Chapters
00:00 The Question
01:16 Writing Basic Logical Statements
02:51 Writing Logical Tests in If Statements
04:55 Asking If a Logical Test Returns False
06:44 Using the Not Operator
08:08 Returning Boolean Values from Functions
09:52 Using Boolean Functions in an If Statement
11:10 Testing If a Boolean Function Returns False
12:52 Comparing Objects or Reference Types in VBA
15:57 Comparing Objects using Not Is Syntax
18:07 Testing If a Reference Type Is Nothing
20:53 Testing If a Reference Type Is Not Nothing
22:02 Testing the Result of Application.Intersect
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Видео Wise Owl Answers - Why Do We Write If Not Is Nothing in Excel VBA? канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![](https://i.ytimg.com/vi/UrHFnoqT44E/default.jpg)
![Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)](https://i.ytimg.com/vi/dUSQ7wZHM7A/default.jpg)
![[Q & A Response] Excel VBA: How to Cut/ Copy Row of Data Based on a Condition || Two Techniques](https://i.ytimg.com/vi/iLckSTpE7DE/default.jpg)
![How to make your Excel VBA code run 1000 times faster.](https://i.ytimg.com/vi/GCSF5tq7pZ0/default.jpg)
![Débuter avec VBA Excel et la programmation](https://i.ytimg.com/vi/sYgHG_uJ2Pw/default.jpg)
![SQL Server Programming Part 1 - Stored Procedure Basics](https://i.ytimg.com/vi/fjNsRV4zLdc/default.jpg)
![How to Solve a VBA Error in Less Than a Minute](https://i.ytimg.com/vi/79i0zeBE1ec/default.jpg)
![How to Prevent Duplicate Entry in Excel VBA - Part 2](https://i.ytimg.com/vi/uEzJRiL5GM8/default.jpg)
![#Excel VBA to Select the Next Empty Cell or Row - Macros](https://i.ytimg.com/vi/tBXW456R6_E/default.jpg)
![Wise Owl Answers - Is it Possible to Start Chrome Hidden using Selenium in VBA?](https://i.ytimg.com/vi/AKTr_reqZ30/default.jpg)
![Sorting with Excel VBA](https://i.ytimg.com/vi/LE_YdsAy4Kk/default.jpg)
![Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros](https://i.ytimg.com/vi/78GvLEAZecs/default.jpg)
![6 Ways to Speed up your Excel Macros](https://i.ytimg.com/vi/B5mrj9keRds/default.jpg)
![Excel VBA: Using the MultiPage Control in your Userforms](https://i.ytimg.com/vi/QID8qSou0jQ/default.jpg)
![How To Validate Userform Inputs With Excel VBA (Excel Userforms For Intermediates 2)](https://i.ytimg.com/vi/3rEVWjmIBE4/default.jpg)
![Excel - Conditionally Lock Cells Based on Other Values](https://i.ytimg.com/vi/VudPtXCf2bU/default.jpg)
![Advanced excel(vba) tutorial 14 : Data type validation functions ISDATE, ISNUMERIC, ISEMPTY](https://i.ytimg.com/vi/7Es8izu4uLU/default.jpg)
![Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)](https://i.ytimg.com/vi/KkTaQ5OjAGc/default.jpg)
![Wise Owl Answers - How Do I Access Elements in the Shadow DOM using Selenium in VBA?](https://i.ytimg.com/vi/phYGCGXGtEw/default.jpg)
![Excel Macro VBA Tip 9 - Enter Formulas in Excel with a Macro](https://i.ytimg.com/vi/317P-hH0QwM/default.jpg)