iTrain Scotland IT Training Edinburgh image
 

Microsoft Excel VBA

iTrain Scotland IT Training Edinburgh image

Home > Courses > Microsoft courses > Microsoft Excel VBA

Microsoft Excel VBA

Whether you are a new user or have been using Excel VBA for years, this course will vastly increase your understanding of Excel VBA. Existing users will learn how to get the most out of Excel VBA, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Excel VBA trainers.

This course has been designed for advanced users of Microsoft Excel who are looking to develop macros and learn how to code with VBA.

 

Delegates will learn how to code using VBA. Delegates will also learn shortcuts and tips about how to use Excel VBA in the most efficient way.

 

Introduction to Macros
  • What is a Macro?
  • Recording a Macro
  • Running a Macro
  • Relative References
  • Assigning a Macro to a Button on a Worksheet
  • Assigning a Macro to a Button on a Toolbar
  • Button Image Editor

Editing Macros
  • The Visual Basic Editor
  • The Project Explorer
  • The Code Window
  • Procedures
  • Inserting Comments
  • Printing a Visual Basic Module

The Range Object
  • What is the Range Object?
  • The Cells Property
  • The Range Property
  • Flexible Ranges
  • Range Contents

Workbooks and Sheets
  • Activating a Workbook
  • Activating a Worksheet
  • ThisWorkBook

Debugging and Error Trapping
  • What are Errors?
  • Types of Error
  • Break Mode
  • Instant Watch
  • Stepping Through Code
  • Error Handling Worksheet and Workbook Events
Objects, Properties and Methods  
  • Controlling Objects with their Properties
  • Performing Actions with Methods
  • Performing Multiple Actions on an Object

Variables and Constants Control Structures
  • Conditional Control Structures
  • Looping Control Structures
  • Non-Structured Statements
  • Subprocedures

Controls, Dialogue Boxes and Forms
  • Built-In Dialogue Boxes
  • Predefined Dialogue Boxes
  • Custom Forms
  • Worksheet Forms
  • Setting the Properties of a Control
  • User-Defined Forms
  • Adding Form Controls
  • Form Control Properties
  • Control and Dialogue Box Events
  • Displaying and Dismissing a User Form
  • Handling Form Controls

Toolbars and Display
  • About Toolbars and Menus
  • Attaching Toolbars to Workbooks
  • Saving More Than One Toolbar Configuration
  • Customising Toolbars
  • Display Techniques

Function Procedures
  • Function Procedures
  • User-Defined Functions
  • Function Wizard
  • Excel Functions

Add-in Applications
  • What is an Add-in?
  • Creating an Add-In
  • Converting an Add-In to a Workbook
Group discount
1 place £ 355 n/a
2 places £ 710 n/a
3 places £ 1065 £ 965
4 places £ 1420 £ 1220
5 places £ 1775 £ 1475
6 places £ 2130 £ 1730
7 places £ 2485 £ 1985
8 places £ 2840 £ 2240