Duration
1 day
Introduction
This course will teach you how to create visual basic macros, understand the basics of object orientated programming and manipulate code to suit your needs.
Objectives
Participant will get in-depth knowledge on
- Record and Run Macros
- Write VBA Code Manually
- Perform Loops, Controls and Error Handling
- Create User forms and Sheet Controls in Excel
- Use Events to trigger specific VBA code
Lesson 1: Using Expressions, Variables, and Intrinsic Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
Lesson 2: Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If…End If Decision Structures
- Using the Select Case… End Select Structure
- Using the Do…Loop Structure
- Using the For…To… Next Structure
- Using the For Each…Next Structure
- Guidelines for use of Control-of-Flow Structures
Lesson 3: Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForms Properties, Events, and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with the Label Control
- Working with the Text Box Control
- Working with the Command Button Control
- Working with the Combo Box Control
- Working with the Frame Control
- Working with Option Button Controls
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
Programme scope, delivery arrangements and suitability are confirmed during enquiry.