Excel VBA Introduction
Course
Inhouse
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Inhouse
-
Duration
2 Days
-
Start date
Different dates available
Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.
Facilities
Location
Start date
Start date
About this course
Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.
Reviews
Subjects
- Excel
- Basic
- Visual Basic training
- IT
- Basic IT training
- Basic IT
- Visual Basic
- MS Excel
- Excel on-site training
- Excel in-house training
- Excel training
Course programme
Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment.
Basics Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your code, Stepping through macros, Getting help on macros, Objects, properties and methods, About Excel objects, Using the Object Browser Range object The Selection property, The Range property, Targetting cells, Counting the cells in a selection, Using the Offset statement, Retrieving the value of a cell, Retrieving a formula from a cell, Setting the value of cells Charts and drawing About programming charts, Assigning a range to a chart, Positioning a chart, Drawing shapes, Setting shape attributes Using Visual Basic Language structure, Using variables, Declaring variables, Scoping variables, Data types, Using constants, Using the VBA debugger, Making decisions, If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays Interactivity Assigning a macro to a menu, Assigning a macro to a toolbar, Assigning macros to other objects, Built-in dialogue boxes, Creating custom forms, Using the Form Editor , Using form controls
Additional information
£900 for one-to-one training
£1,100 for groups of up to 6 people
£1,300 for groups of up to 12 people
Excel VBA Introduction