Microsoft Excel VBA (Intro)

Reduce manual tasks to the click of a button by leveraging Excel functionality with VBA (MACROS): automate repetitive tasks and create interactive models to analyse, consolidate & report on data.

• Introduction (2 days): Suitable for advanced users who (i) Are responsible for large/ variable amounts of data (ii) Want to learn how to program features to improve the accessibility &usability of their data
• Intermediate (1 day): Covers the use of arrays, control structures, adv error handling, validation
• Advanced (1 day): Looks at 3-D arrays, user forms, performance, etc

Benefits:

• At the end of the course the delegate will have covered the fundamentals of VBA, including:
• working with procedures and functions
• understanding objects
• using expressions, variables and intrinsic functions.

Content:

• Introduction
• • What is a Macro
• • Recording a Macro
• • Relative References
• • Running A Macro
• • Running A Macro From The Macros Dialog Box
• • Editing A Macro With Visual Basic
• Assigning Macros To Buttons And Objects
• • Assigning a Macro to a Button on a Sheet
• • Assigning a Macro to a Drawn Object on a Sheet
• • Creating A Short-Cut Key To Run A Macro
• Visual Basic Editor
• • Objects
• • Methods
• • Properties
• • Programming Tools
• • The Menu Bar
• Editing Macros
• • The Visual Basic Editor
• • The Project Explorer
• • The Code Window
• • Procedures
• • Inserting Comments
• • Printing a Visual Basic Module
• The Range Object
• • The Cells Property
• • The Range Property
• Workbooks And Sheets
• • Activating a Workbook
• • Activating a Worksheet
• • ThisWorkBook
• • Running Code
• • Run Mode And Design Mode
• • Running Code From The Development Environment
• The Project Explorer
• • Using The Project Explorer
• The Properties Window
• • Changing A Property
• Using Constants
• • Excel Constants
• • Variable Constants
• and more