Category Archives: Operators

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

Your Guide to Using Operators in VBA

An introduction to operators An operator is a symbol that works on two operands to provide an output. For example, Let us consider expressions below:  A + B = C here A, B and C are called operands And + and = are called operators.

How to Use the Mod Operator in VBA

Introduction Mod stands for Modulo. It is a mathematical operator that returns the remainder, or modulus, of a number after performing division. The Mod operator is not only helpful when you want to know the remainder in division, it is also powerful when you want