Excel: VBA Programming (2 day)

Course Overview

This course focuses on advanced methods of data management through powerful VBA tools.

Audience

This course is suitable for people who would like to use VBA to enhance their usage of Excel for a more professional result. A thorough understanding of Excel formulas and functions is required.

Skills Gained

You will learn how to write programmes to maximise existing Excel functionality.You will gain a complete understanding of how to edit amend and update the VBA programmes.Learn how to utilise advanced 'If' statements and macros to automate repetitive, tedious or complex tasks.

Course Outline

• Macros
• Recording, Editing, Debugging and tracing errors in Macros
• Assigning Macros to a Button
• Range Objects
• Range Object Flexibility and Constraints
• Cell and Range Properties
• Workbooks and Worksheets
• Activating Worksheets and Workbooks through VBA
• Toolbars and Displays
• Customising Attaching and saving Multiple Toolbars
• Objects and their Properties
• Controlling Objects And Properties
• Actions and Methods
• Performing Actions with Associated Methods
• Multiple Actions
• Constants and Variables
• Controlling Loops
• Structure Control and Conditional Structure Control
• Sub-Routines and Non-Structured Information
• Customising Forms and Dialogue Boxes
• Using Forms with Pre-Defined Dialogue Boxes
• Form Controls and Properties
• Customised Forms
• Information Storage
• VBA Settings Storage Files
• Windows Registry
• Adding in other Applications
• What are Add-Ins
• Generating an Add-In
• Using Add-Ins in a Workbook