
Session 1
Using Excel's macro recorder -
Running recorded macros
- Editing code in the VBA(Visual
Basic for Applications) editor
- Adding comments to code
- Assigning a macro to a button
Session 2
The limitations of the macro
recorder
- An introduction to variables -
The VBA data types (the Dim
statement)
- Assigning values to variables
Session 3 The structure of VBA:
Modules and Procedures
Objects, Properties and Methods
Session 4
Using the If statement -
Using the Select Case statement
Session 5 Looping through code using
ForNext
Session 6 Looping through code using
DoWhile and DoUntil
Session 7
Debugging code
- Stepping through code
Using the watch window and
break points
Session 8 Customising Message Boxes
Using Input Boxes
Session 9 Working with User Forms
Project:
Developing a simple database
enquiry system
|