Information Technologies

Microsoft Excel VBA Programming

hours

6

language

English

Target Audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel or have equivalent practical experience.

Topics Covered

  • Topic A: Visual Basic for Applications
  • Topic B: Object programming
  • Topic C: The Object Browser
  • Topic A: Data basics
  • Topic B: Scope of variables
  • Topic C: Scope of procedures
  • Topic A: Decision structures
  • Topic B: Loop structures
  • Topic A: User forms
  • Topic B: Events
  • Topic A: Errors
  • Topic B: Debugging
  • Topic C: Error handling
  •  
  • minimize course outline