VBA Concepts

We can interact with the other applications using VBA - with the MS Office Applications like Word, PowerPoint,Outlook,etc... and other applications like Internet Explorer, SAS,etc.

In this Section:

• Introduction?
• How to interact with MS Word? - Late Binding
• How to interact with MS Word? - Early Binding
• How to interact with PowerPoint? - Early Binding
• How to interact with Outlook? - Late Binding
• Example File

Getting Started with VBA - Welcome to VBA programming tutorials, In this session we will see brief introduction of the topic required to understand VBA programming.

It is important to understand the macro security if you are dealing with the Macro Enabled Files. It helps to protect your data from the malicious programs and helps to know how to run the macros when its required.

In this Section:

• Understanding VBA Security
• What are the different Levels of the Security in VBA?
• How to Enable or Disable the Macros?
• How To Protect VBA Code?

Any Windows Application is equipped with set of objects called windows controls. The Main control is called a Form, it is the primary window contains different types of controls which allow user to interact with the computer. The following is a simple form to calculate square value of a given number.

In This Section:

• What Are UserForms?
• What Are ActiveX Controls?
• What Are The Different UserForm Controls & Use?
• Practical Learning: Developing A Simple UserForm
• Example File

We write the procedures to perform certain tasks and some times we may required to write another procedure with small variations. In this situation we can take advantage of the Passing Arguments.

In this Section:

• What are By Value (ByVal) and By Reference (ByRef) Passing Arguments?
• Writing a procedure or a function with Arguments
• How to call a function or a procedure?
• Example macro file to explain passing arguments

When we work with one item we required to use one variable, if you want work with more than one item, we can go for arrays. Arrays are the variables which allow us to store more than one value.

In this topic:

• What is an Array?
• What are the different types of arrays?
• One Dimensional Array:
• Multi-Dimensional (Two Dimensional) Arrays:
• How to Re-size an Array?
• Array Options
• Example File

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

Macro Security in Excel VBA is provided to secure your data or PC from others or from the malicious programs. Learn more about macro security here.

VBA Environment we also refer as VBE. You can goto Developr tab in the ribbon and Click on the Visual Basic button to go to the VBE or simply press 'Alt+F11' to go to the VBE