Author name: Umesh Manral

VBA String Operator

String operators are used to manipulate string data. A string can include alphabets, numbers, and special characters in a sequence. A string’s special advantage is that it can contain all kinds of characters in a single string. For example, you can concatenate the value of  “Hello” and “World” in a single string. Examples of Strings …

VBA String Operator 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-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 »

VBA Logical Operator

VBA Logical Operator

Let’s say you Want to Take a Customer Order, and for that, you First Want to Check Whether the Ordered item is Actually Available. If so, you Want to Double-Check the Amount of Each. Logical Operators Come in Handy in Such Instances. The Main Excel VBA Logical Operators are AND, OR, and NOT. Operator Meaning …

VBA Logical Operator Read More »

VBA Arrays

VBA Arrays

The C programming language provides a data structure called the array, which can store a fixed-size sequential collection of elements of the same type. An array is used to store a collection of data, but it is often more useful to think of an array as a collection of variables of the same type. Instead …

VBA Arrays Read More »

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, functions, constants, literals, property calls, and other expressions. The following arithmetic operators are supported by VBA: Addition (+): This operator is used to add up …

VBA Arithmetic Operators Read More »

VBA Constant

VBA Constant

A constant is a named memory location that holds a value that cannot be changed during script execution. If a user tries to modify a Constant value, the script execution ends in an error. The same principle applies to constants, as to variables. Constants can be of any of the basic data types like an …

VBA Constant Read More »

vba-variables

VBA Variables

What are VBA Variables A variable is nothing but a name given to a storage area that our programs can manipulate. Each variable in C has a specific type, which determines the size and layout of the variable’s memory; the range of the values that can be stored within that memory; and the set of …

VBA Variables Read More »

what-is-macro

What is Macros

Macros are a set of programming commands written in VBA that automate a repeated and standard process in Excel and other Microsoft Office Applications such as Access, PowerPoint, Word, and Outlook. Through the use of macros, we can automate repetitive tasks associated with data manipulation and data reporting that must be performed repeatedly. Important of …

What is Macros Read More »

vba-editor

VBA Editor

The Visual Basic Editor, also known as VBA Editor, VB Editor, or VBE Editor, is a separate application that first needs to be familiarized with to work with VBA in Excel. It is part of Excel and appears whenever you open an Excel workbook. By default, it is hidden and must be activated to view …

VBA Editor Read More »