Excel – VBA Basics

Excel – VBA Basics

Excel – VBA Basics

VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word and MS-Access. This tutorial teaches the basics of VBA. Each of the sections contain related topics with simple and useful examples.

Audience

This reference has been prepared for the beginners to help them understand the basics of VBA. This tutorial will provide enough understanding on VBA from where you can take yourself to a higher level of expertise.

Prerequisites

Before proceeding with this tutorial, you should install MS Office, particularly MS-Excel.

Lessons

  1. VBA – An overview

  2. The Macro Recorder

  3. The Visual Basic Editor’s Code Window

  4. Variables and constants

  5. Editing macros

  6. Statements

No Comments

Post a Reply

Teachers