VBA for MS Excel 2010 tutorial-VBA programming ?

VBA programming ?

In this VBA for MS Excel 2010 tutorial, you will learn various topics of VBA programming in MS Excel 2010 version. In this version of MS Excel, Microsoft added some new objects to its Object Model (e. g Entity, NavigationControl, Webservice, etc). Some properties, methods, and events also added to the existing objects. However, the core of VBA programming language doesn't change across Microsoft Office packages.

Where can you write the VBA code in MS Excel 2010? Simply you can write your VBA code by using Visual Basic Editor. To open Visual Basic Editor, after opening a database, you can press Alt with F11. The Visual Basic Editor window looks like this:

VBA Editor in MS Excel 2010


Dara comment



Tamilan comment


Pls post some examples for declaring and calling variables (local and global)


This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.