VBA – User Defined Functions
A function is a group of reusable code which can be called anywhere in your program. This eliminates the need of writing the same code over and …
Macros
VBA – Arrays
We know very well that a variable is a container to store a value. Sometimes, developers are in a position to hold more than one …
VBA – Date-Time Function
VBScript Date and Time Functions help the developers to convert date and time from one format to another or to express the date or time …
VBA – Strings
Strings are a sequence of characters, which can consist of either alphabets, numbers, special characters, or all of them. A variable is said to be …
VBA – Loops
There may be a situation when you need to execute a block of code several number of times. In general, statements are executed sequentially: The …
VBA – Decisions
Decision making allows the programmers to control the execution flow of a script or one of its sections. The execution is governed by one or …
VBA – Operators
An Operator can be defined using a simple expression – 4 + 5 is equal to 9. Here, 4 and 5 are called operands and + is called operator. VBA …
