VBA For Loop

As we’ve mentioned already, loops are used to repeat a set of statements as many times as necessary until a given condition is met. They help to refract your code, reducing the number of specifically coded actions that must be performed to improve the speed and efficiency of your applications. Flow Diagram Things to Consider …

VBA For Loop Read More »

VBA Loops

This VBA Loops tutorial shows you how to use the different types of loops in VBA such as For Next, For Each, Do While, and Do Until, with code examples. Loops are an essential feature of programming languages since they enable us to repeat certain actions by using fewer lines of code. In this tutorial, …

VBA Loops Read More »

Excel VBA InStr

The VBA InStr function is used to find out if a string is contained in another line of text and it returns the first position of its occurrence operations. If the text is not found, it returns (0), otherwise it returns the character in which the text is found. For instance, if you want to …

Excel VBA InStr Read More »

VBA MsgBox

A MsgBox is nothing more than a dialog box that can be used to inform your users by displaying a custom message or getting some basic inputs (such as Yes/No or OK/Cancel). While the MsgBox dialog box is displayed, your VBA code is halted. You need to click any of the buttons in the MsgBox …

VBA MsgBox Read More »

VBA Select Case

VBA SELECT CASE is a statement for testing multiple conditions. In this Statement, you can First Define a Condition and Then Specify a Code to Run if that Condition is True, Then Specify a Second Condition and a Code to run if That Condition is True. So, Multiple Conditions and Statements can be Entered. The …

VBA Select Case Read More »

VBA Data Types

In this tutorial, you’ll learn about different numeric and non-numeric data types supported in VBA, as well as data type conversions. We encounter many types of data every day, such as name, date, bills, the price of a product, etc. The data in each field belongs to a specific type, and their values cannot be …

VBA Data Types Read More »

VBA-20Comparison-20Operator.png

VBA Comparison Operator

Comparison operators can be used to compare numbers or strings and perform evaluations. Expressions using comparison operators do not return a number value, as do arithmetic expressions. Comparison expressions return either 1, which is true, or 0, which is false. Some comparison operators include equal to, less than, greater than, and not equal to. In …

VBA Comparison Operator Read More »