Visual Basic Programming Intro

Objective

This session is aimed at the person who is new to programming and to Visual Basic. The new user will be led step by step through the various topics listed below and the final part of the session will comprise a case study designed to incorporate all of the features into a working module.

For the existing Visual Basic user, we can tailor a session.

Topics:

Day 1

Overview of Macros In Excel

Recording – Absolute / Relative
Using Macro Buttons and Shortcuts
Relative / Absolute Select

Behind the Scenes

Navigating the Project Explorer
Modifying Macro Code

VB Concepts

Declaring Variables & Constants
Scope

Object Models

Objects and Collections
Methods and Properties

VB Techniques

Conditional Statements
Loops
Functions

Day 2

Buttons

Button Wizard
Understanding Code

Events

Building Properties
Using Object Model

Communicating with the User

Manipulating Properties
Message Boxes
Modal Forms

Communicating with Other Software

Introduction to API’s
Automating Outlook
References
Early / Late Binding

Debugging

Using Breakpoints
Stepping Through Code


Print Friendly