VBA variables in Excel

In this article we will learn about what are different types of variables used in VBA and how to use them. What are VBA variables ? VBA stands f...

Operators in Excel VBA

The signs and keywords we use to operate variable in VBA are called VBA Operators. For example, in the lines below lines =, +, >, & are operato...

How to Declare VBA Constants in Excel

The Pi's value is 3.14, the gravitation pull of the Earth is 9.8 m/s2, you have an interest in VBA, etc. These all are constants and they don't change...

Excel VBA Variable Scope

In all the programming languages, we have variable access specifiers that define from where a defined variable can be accessed. Excel VBA is no Except...

How to Connect Excel to Access Database using VBA

The Access database is a relational database management system that effectively saves a large amount of data in an organized manner. Where Excel is a ...

Excel VBA If Then Else Statement

Related Articles: Embedded Chart Events Using VBA in Microsoft Excel | The embedded charts events can make your chart more interactive, dynamic, a...

Change Chart Data as Per Selected Cell

If you want to make a dashboard with a chart that changes its data as per the selected options, you can use the events in VBA. Yes, it can be done. We...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube