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
