Microsoft Excel VBA Computer Training

Duration – 2 days

Overview

This course is aimed at Excel users who are familiar with its capabilities and need to use VBA, (Visual Basic for Applications) to develop more complex spreadsheets.

Delegates work through a series of practical exercises to extend their skills. On completion of the course delegates will be able to apply the tools and techniques covered to develop Excel applications.

Content

• Macros…
  Recording, running and editing a Macro
  Absolute and Relative navigation
  Adding a Command Button to a Worksheet
  Assigning a Macro to a Command Button
• The VBA Editor
  Finding your way around the VBA screens…
  Code Window
  Project Explorer
  Object Browser
  Properties Window
  Locals Window
  Help Options
  Excel sample file - SAMPLES.XLS
• VBA Basics…
  Procedures, Functions and Modules
  Variables, Constants and Arrays
  Control Structures - Conditions and Loops
  Auto List and Auto Quick Info
  Layout and comments
  Naming conventions
• Selecting and activating objects
  How do I get to where I want to be?
  Range
  Worksheet
  Workbook
• User Defined Functions
• Communicating with users…
  MsgBox and InputBox
  Forms and Controls
  Form and Control Properties
  Displaying and hiding Forms
• Toolbars and Menus…
  Customising and creating Toolbars
  Customising and creating Menus
  Assigning Macros and Procedures to Menus and Toolbars
  Displaying and hiding Toolbars and Menus
• Debugging and Error-Handling…
  Finding out what is really happening
  Suspending execution
  Stepping options
  The Local Window
  Disabling suspect lines of code
  Error-Handling options
• Excel Objects, Properties, Methods and Events
• System Design Considerations…
  The specification
  Thorough, careful planning
  Consultation with users
  Consistency of style
  Ease of use
  Protecting your application
  Documentation