Category Archives: VBA

How Nested Ifs In VBA Work with Examples

All programming languages support the “if” type of conditional statement. An if block is executed during runtime only if the condition is met. i.e., the result of a condition is equal to the Boolean value “true.” Syntax If ( <conditional expression> ) ‘block of statements

How to Use IfError in VBA and Excel

Errors Happen We may come across several functions in programming languages. In VBA, we are prone to encounter errors like:  Syntax errors Compile time errors Runtime errors These are errors in code which can be handled using error handling methods. For example, you can see

No Thumbnail

Using VBA Like to Compare Strings

What is a Regular Expression? How is the Like Operator Related? In any programming language, there is a way to compare strings against some patterns. Several characters are used to create these patterns. These patterns are called regular expressions. Like in structured query language, VBA

How to Use the Boolean Data Type in VBA

Introduction to Flag Options in Programming In any programming language, there’s a need to set a variable to options like on/off, true/false, yes/no. This variable is then later used in the code to check or understand something else. For example, let us imagine that we

The Set Keyword in VBA: How to Use and Examples

Before we get into the Set keyword, I’m going to quickly go over a couple fundamentals about objects in VBA. If you already know this stuff, just skip ahead a couple sections. Introduction to Objects An object in a programming language is a class with

How to Use the With Statement in VBA

Working On an Object As in any other language, in VBA too there may be situations where we continuously work on a specific object.  For example, we may like to apply conditional formatting to a cell based on its information by changing the font face,