By Sections






By Levels





Other Links



VBA Section 1: The VBA for Excel Programming Environment

The programming environment in VBA for Excel is one of the most friendly and forgiving. Its two main components are the Visual Basic Editor and the Macro Recorder. The latter will be your teacher (and a very good one) for the first few weeks . It will then become your permanent assistant writing long sentences of code without complaining and without typos.

In this section we will also study the security aspects in the VBA for Excel environment and the events (what triggers the VBA procedures).

The lessons in this section are:

Lesson 1-1: The Visual Basic Editor (VBE)
Lesson 1-2:
The Project  Window

Lesson 1-3:
The Properties  Window

Lesson 1-4:
The Code  Window

Lesson 1-5:
Developing Macros in the VBE

Lesson 1-6:
Testing Macros in the VBE

Lesson 1-7:
VBA Security and Protection

Lesson 1-8:
Excel Macro Recorder

Lesson 1-9:
Modifying Macros in the VBE

Lesson 1-10:
VBA Events


Developed and Presented by PLI Consultant Inc