In the previous article, we learned about the Collections in VBA. Today, we would implement the searching by checking if a particular item exists in… Read Article

In this blog, we would learn about Collections in VBA. It has a lot of applications in the VBA programming language. We kept the article… Read Article

In the previous part, we learn about passing procedure arguments by reference. Today we would learn another approach to passing parameters to a procedure. This… Read Article

We have practiced the Sub Procedures and Functions in VBA. Today, we will learn about the scope of procedures. The Private and Public Procedures in… Read Article

We already know about Sub Procedures and Functions in VBA programming. The Sub Procedure is used to execute a block of code without returning any… Read Article

In the previous article, we learned about the variables in the VBA Programming language. Variables contain values that can be changed during the program execution.… Read Article

In the previous article, we learned the use of variants. Today we would learn about another interesting topic. Strings are one of the frequently used… Read Article

Previously. we learned about various numerical and nonnumerical data types in the VBA programming language. Today, we would learn about another particular data type which… Read Article

In the previous blog, we learned about the usage and declaration of variables in VBA Programming. Today we will cover different data types of the… Read Article

Variables are one of the basic building blocks of any programming language. Today we will learn about different variables in VBA, naming conventions for a… Read Article

Static Variables in VBA are particular kinds of variables that are used in different situations. The usage of a Static Variable in VBA is irreplaceable.… Read Article

In today’s article, we are going to learn about how to run a set of instructions via a macro when a workbook is opened. Running… Read Article