Visual Basic is engineered for productively building type-safe and object-oriented applications. Visual Basic enables developers to target Windows, Web, and mobile devices. As with all languages targeting the Microsoft .NET Framework, programs written in Visual Basic benefit from security and language interoperability.
Target audience: Experienced users of Excel who have attended Excel level 3 training
Duration 1 Day
Objectives For users wishing to automate Excel procedures by writing macros and gain a rudimentary understanding of Visual Basic.
Recording Macros and Running Macros
Editing a macro
Global macros using the Personal Macro Workbook
Absolute v Relative cell Addressing
More Complex Macros
Using the VB Toolbar
Debugging macros using Step
Introduction to common VB statements
Repetitive Tasks within Macros
Making decisions (IF)
Ending a macro