Wise Owl Answers - Why Do We Write If Not Is Nothing in Excel VBA?

Check out our other answers here    • Wise Owl Answers  

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