Advanced VBA Tutorials (TSM 2007) (New 17/07/08)

These Excel (2003 or later) files and Word files were done for the TSM 2007 organised by Douglas Butler and hosted in Oundle School.
Most of the files are set up as projects that can be worked through by reading their accompanying Word notes and either typing in the VBA code in your own, new Excel files or simply inspecting the associated Excel files as supplied. However, when learning VBA there is often no real substitute for typing the code in yourself both to familiarise yourself with how the VBA editor works and to become acustomed to the new language and its syntax.

The projects with their many Excel files and associated, detailed Word notes given are:

• VBA Case Statements verses Conditional Formatting
• An Introduction to Control Structures
• Worksheet Events

For all of the below (and above) you may find the following Visual Basic Editor (VBE) Help-Sheet useful as your skills at interrogating and moving around code grow

• VBE Help-Sheet

The projects having just the Excel files for you to investigate the code yourselves are:

• Control Structure Project:
  Filling a fixed-sized Grid with Numbers in several ways
• Control Structure and Worksheet Events Project:
  Filling a variable-sized Grid with Numbers and identifying Multiples and Primes within it