VBA Concepts

Home/Tag: VBA Concepts

VBA concepts help you to understand the programming techniques of VBA to master in macro programming language for MS Office Tools.

Scope of Variables in Excel VBA

When we are working with variables, it is important to understand the Scope of a Variable. The Scope describes the the accessibility or life time or visibility of a variable. There are four levels of Scope:

  • Procedure-Level Scope
  • Module-Level Scope
  • Project-Level Scope
  • Global-Level Scope

Introduction to VBA

VBA is a common language for all MS Office Tools (Excel, Word, PowerPoint,Outlook,Access), if you learn Excel VBA, you can able to automate any MS Office Tool , the only change is object model.

In this session:
  • Introduction to VBA
  • Why should I learn VBA?
  • What things can we do using VBA?
  • How many ways we can automate tasks using VBA?
By |January 27th, 2013|Excel VBA|7 Comments

Advanced Excel VBA Programming


Advanced VBA Programming helps you to develop user friendly applications.Learn by following our easy to follow step by step tutorials and automate any task.

In this Section:
  • Advanced VBA Programming - Learning Outcomes.
  • Learning Path (TOC): Start Learning Advanced VBA.
  • Are you feeling these topics are more advanced? Don't panic!
  • Are you novice to Excel? Start Learning from the Basics!
  • I have completed Advanced VBA, What Next?
By |January 12th, 2013|Excel VBA|15 Comments

Excel VBA Programming

Excel VBA Programming helps to learn from the basics to write your own VBA programs like sub routines, functions to automate your daily tasks. By end of this session you will be able to write the procedures and functions to automate tasks and you will find significant time saving while working with your projects. Topics

By |January 5th, 2013|Excel VBA|0 Comments