 |
| Home |
| Services |
| Products |
| Training |
| Case studies |
| Contact us |
| Visual Basic Primer (2 days) | View course dates Print page |
Purpose
The purpose of this class is to provide a basic understanding of the Visual Basic programming language using Excel VBA. Each topic is reinforced through practical exercises. The class aims to develop sufficient Visual Basic skills to be able to understand Excel macros, as well as to use Visual Basic programming to enhance the capability of Excel spreadsheets.
Prerequisites
Attendees should have a sound understanding of Microsoft Office products, in particular Microsoft Excel. It is preferable that the student has some previous programming experience though this is not essential.
Class Content
Introduction
VBA Programming Environment
Understanding VB Objects
Debugging
Error Handling
Intellisense
Variables
Understanding Expressions
Variable Scope
Variable Types
Constants
Variable naming conventions
Arrays
Strings
Built in String Functions
String Concatenation
Conditional Programming & Loops
Use of If, Then, Else
Nested programming
For / Next loops
Do / While loops
Functions and Subroutines
Use procedures in Programs
Program Flow
Form Objects
Worksheet Object
Command Button
Label
List Box
ComboBox
| Copyright © 2008 Indian Point Ltd. All rights reserved. | Trademarks | Privacy Policy |