Category: VBA

Browse all posts in the VBA category.

November 1, 2023 Umesh Manral 0 Comments VBA

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…

Read More
October 1, 2023 Umesh Manral 0 Comments VBA

VBA Events

Visual Basic for Applications (VBA) is a programming language used primarily for automating tasks in Microsoft Office applications, such as Excel, Word, and PowerPoint. Events in VBA allow you to…

Read More
September 2, 2023 Umesh Manral 0 Comments VBA

If Else If Statement

If Then, If Then Else and If Else If statement makes the programmers control the execution flow of a script or one of its sections. Below image is the general…

Read More
September 2, 2023 Umesh Manral 0 Comments VBA

Nested If Statement

Nested If Statement. VBA Programming is a major area of relying on the If-Else statements. In this lesson, we will explore various ways to implement conditional statements in VBA (If..Else…

Read More
August 21, 2023 Umesh Manral 0 Comments VBA

VBA Arithmetic Operators

VBA Arithmetic Operators are used to perform operations such as adding, subtracting, multiplying, and dividing of numbers. In these operations, numeric values are calculated and they are represented by variables,…

Read More
August 21, 2023 Umesh Manral 0 Comments VBA

VBA MsgBox

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…

Read More
August 21, 2023 Umesh Manral 0 Comments VBA

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…

Read More
August 21, 2023 Umesh Manral 0 Comments VBA

VBA MID Function

People often use the MID Function to get a substring out of a full-text string. It’s considered a variable of the String type. The VBA Mid function lets you get…

Read More