VBA

VBA Comments

Comments are lines of code skipped over when the code is run. In the coding, these are shown as green text. Descriptions of the code are provided in the comments. A comment is any remark in the VBA code after an apostrophe. Knowing the proper usage of comments is crucial when working with large and …

VBA Comments Read More »

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 form of structure found in most programming languages. If Then Statement The If-then statement is the simplest of all control flow statements; it tells your …

If Else If Statement Read More »

VBA For Each Loop

A For Each loop is used to execute a statement or a group of statements for each element in an array or collection. A For Each loop is similar to a “For” Loop, but the loop is run for each element in an array or collection. In this type of loop, the step counter will …

VBA For Each Loop Read More »

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 »

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 nested IF). In VBA, there are several powerful data manipulation tools; in the later part of the tutorial, we will see how IF ELSE statements are commonly used …

Nested If Statement Read More »

VBA Functions

A function is a group of statements that together perform a task. Every C program has at least one function, which is the main one, and all the most trivial programs can be defined as additional functions. Program codes can be divided into separate functions depending on the user’s initiatives but logically the division usually …

VBA Functions Read More »