VBA

What is Data Scraping? Data scraping is the technique that helps in the extraction of desired information from a HTML web page to a local file present in your local machine. Normally, a local file could correspond to an excel file, word file, or to say any Microsoft office application. It helps in channeling critical…

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 VBA. By using Excel VBA range object, you can refer to, A single cell A row or a column of cells A selection of cells A 3-D range As…

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 out repetitive tasks such as formatting data for output, performing calculations, etc.

Suppose you are developing a program that calculates interest on a loan. You can create a function that accepts the loan amount and the payback period. The function can then use the loan amount and payback period to calculate the interest and return the value.

What is a Subroutine in VBA? A Subroutine in VBA is a piece of code that performs a specific task described in the code but does not return a result or a value. Subroutines are used to break down large pieces of code into small manageable parts. Subroutines can be recalled multiple times from anywhere…

VBA Logical Operators: AND, OR, NOT Excel VBA Logical Operators Let’s say you want to process a customer order. For that, you want to first check to see if the ordered product exists or not. If it does, you also want to check if the quantity on hand is enough. Logical operators come in handy…

VBA Comparison Operators These are operators that are used to compare values. Comparison operators include equal to, less than, greater than and not equal to Comparison operators are used to compare values for validation purposes. Let’s say you are developing a simple point of sale application. In this application, you want to validate the values…

VBA String Operators String data is used to hold data that is made up of numbers, characters, and symbols. “Jul-2015” is an example of a string data. It is made up of Characters (Jul) Symbol (-) Numbers (2015) String operators are used to manipulate string data. For example, you can concatenate the value of July-2015…

VBA Arithmetic Operators VBA Arithmetic Operators are used to perform arithmetic operations such as adding, subtracting, dividing or multiplying numbers. The following table shows the VBA mathematical operators Operator Description Example Output + Addition: This operator is used to add up numbers 2 + 2 4 – Subtraction: This operator is used to subtract numbers…

VBA Controls: VBA Form Control & ActiveX Controls in Excel 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 with. A GUI is made up of controls. These Excel VBA controls can be used in a Form. The following…