COURSE INFORMATION
This is a programming course using Microsoft Visual Basic for Applications and spans all versions of Excel. A sound knowledge of Excel features, formula and functions is recommended.
- Recording Macros
- Working with the Visual Basic Editor
- Developing Procedures
- Objects
- Declaring Variables
- Managing the Flow of Control
- Debugging
- Message Boxes and Input Boxes
- Creating Custom Forms
- Creating User Defined Functions
- Error Handling
- A good knowledge of the Advanced features in Excel is very beneficial
-
2 day Trainer led or Virtual
- £345