Integer Datatype In Microsoft VBA, variant is a common datatype. It can be used to store strings or integers or even dates. Integer is a specific datatype which can be used to store numbers of a specific length. The bigger version of an integer is
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
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
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
Introduction to Cells In Microsoft Excel, a cell is nothing but an intersection of a column and a row. This cell is referenced by its row number and column letter. A cell can hold a formula/data directly. It can be formatted with font styles and
Component of Excel Sheets Excel sheets are a part of an Excel workbook or a document. There can be any number of Excel sheets in a workbook. A Excel sheet may or may not have any of the below components/contents: Data in cells Formatted cells
Indexes in Programming “Index” is a common term used in all programming languages. It basically acts like a serial number of which an item or value can be referenced. For example, in the picture below, “Great Wall of China” is the 5th item in the
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
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
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,
