Visual Basic For Application: Basic Excel Macro (vba) Orientation Course

Visual Basic for Application Basic Excel Macro (VBA) Orientation Course

Loading…

Course Objectives:

To have a basic knowledge on VBA To be able to learn the VBA Programming Fundamentals To be able to make VBA programs

Course Outline:

Introduction to VBA Getting Started with VBA part 1 Getting Started with VBA part 2 VBA Object Oriented Programming VBA Userforms & Additional Controls

Introduction to VBA: What is VBA Visual Basic -4GL, Visual Program Development, GUI -created in Integrated Development Environment, IDE -Rapid Application Development (RAD) languages Visual Basic for Application -programming language created by Microsoft that can built into applications -Purpose: to enhance and automate operations 1970

-VisiCalc

1983

Lotus 1-2-3

1982

MultiPlan

-part of an Office applications -compatible for Excel 97 onward

1985

Excel

XLM

1994

VBA(Excel 5)

Introduction to VBA: Why use VBA? -Automate tedious processes -Enhance the User Experience -Hide the Underlying Complexity of a spreadsheet -Integrate with another application or database -Prevent the modification of certain aspects of a spreadsheet

Why use Excel? -You can build on the functionality of Excel rather than starting from scratch -Excel is already installed on nearly every corporate PC -Excel applications are easy to distribute -Excel applications can be developed very rapidly -VBA is relatively easy to learn

Introduction to VBA: RELATIONSHIP

Data & Information

Workbook

VBE

Worksheets

Modules

Charts

VBA Codes Userforms

Introduction to VBA:

Getting To Know Your Environment

VBE -Visual Basic Editor -VBA IDE -VBA Development Environment -provides with a number of tools for the development of the program

Getting to the VBA Environment Tools Menu Shortcut

Introduction to VBA:

Getting To Know Your Environment

VBA Development Environment Menu bar Standard Toolbar Project Explorer Window Properties Window Code Window Watch Window Local Window Immediate Window

Introduction to VBA:

Getting To Know Your Environment

Microsoft Excel Objects -Specific/Common functions that are available for the repeated use -Excel Worksheets/Workbooks/Charts/Cells

Forms Userforms that can be added to the project

Modules Container of the procedures or codes

Class Modules Special kind of Module that allows custom objects

Introduction to VBA: Excel Macro -Procedure (VBA) -Record actions and translate it into VBA *Record any task you can do in Excel *Every stroke is recorded, Errors as well

Chapter 1

Chapter 2