Title : Introduction to VBA for Excel


Duration - 1 day

Fees :    £300 for 1 to 6 delegates        £350 for 7 to 10 delegates

(Fees are inclusive of all expenses)

 

 

Content:

  • Setting up the VBA environment

  • User defined functions

  • Record, run and edit simple macros

  • Using the VBA editor

  • Project explorer, properties and immediate windows

  • Importing and exporting modules

  • Creating sub procedures

  • Debug options

  • Variable types and definitions

  • Message boxes and input boxes

  • Introduction to objects, methods, properties and events

  • Uses of With blocks

  • Using if and if else statements

  • Select Case statements

  • Iterations using For/Next and Do Loops

  • User Controls