VISUAL BASIC FOR APPLICATIONS IN EXCEL

Recording Code in Excel

Using the Personal Workbook
Replaying Code
Placing Buttons on Worksheets
Creating Toolbar Buttons to run Macros
Editing the Menu Bar to run Macros

Working with Visual Basic Editor

Navigating a Project in the Project window
Using the Properties Window
Opening the Code Window

Writing and Running Code

Types of Procedures
Entering Code
Run mode and design mode
Running Code from the Development Environment
Running Code from the Host Application

Reusing Code

Exporting a File
Importing a File

Using Visual Basic for Applications

Using Variables
Lifetime and scope of variables
Using and writing Sub Procedures
Using and writing Function Procedures

Controlling Programme Flow

Conditional Structures
If…Then Decision Structures
Logical Operators
For Loops
Do Loops
While...Wend Statement
Select Case Decision Structures

Debugging

Using the break mode
VBA Editing and Debugging

Using Standard VB Functions in your Code

InputBox Function
MsgBox Function
Using a Set Statement

Creating and Using Forms within Excel

Adding a Form to a Project
Adding Controls to a Form
Setting Control Properties

Working with Forms

Displaying a Form
Working with Form Events

Using Microsoft Excel Objects

Opening and Saving Workbooks
Workbook events

Using Worksheets

Selecting a Range of Cells
Inserting and Reading Data from Cells Using VB Objects, Methods and Properties to Manipulate, Read and Analyse Data in a Spreadsheet

Prerequisites: