Category: Excel

What is VBA Range? The VBA Range Object represents a cell or multiple cells in your Excel worksheet. It is the most important object of Excel...

What is a Function? A function is a piece of code that performs a specific task and returns a result. Functions are mostly used to carry...

What is Subroutine? A subroutine is a piece of code that performs a specific task and does not return a result. Subroutines are used to break...

Details Last Updated: 26 September 2020 VBA Logical Operators: AND, OR, NOT Logical Operators Let’s say you want to process a customer order. For that, you...

Details Last Updated: 25 August 2020 VBA Comparison operators These are operators that are used to compare values. Comparison operators include equal to, less than, greater...

Details Last Updated: 25 August 2020 VBA String Operators String data is used to hold data that is made up of numbers, characters, and symbols. “Jul-2015”...

Details Last Updated: 25 August 2020 VBA Arithmetic Operators are used to perform arithmetic operations such as adding, subtracting, dividing or multiplying numbers. The following table...

Creating VBA Form/GUI controls in Excel GUI is the acronym for Graphical User Interface. The GUI is the part of the program that the user interacts...

What is an VBA Array? An array is defined as a memory location capable of storing more than one value. The values must all be of...

Variables are used in almost all computer program and VBA is no different. It’s a good practice to declare a variable at the beginning of the...