This Excel VBA training course is designed for experienced Excel users familiar with both basic and advanced features of the program. The course provides an overview of VBA and the Excel object model and introduces users to basic VBA programming techniques.
Excel VBA overview, Understanding macro steps, Modifying macro steps, Storing values in variables, Adding comments to your code, Stepping through macros, Getting help on macros, Objects, properties and methods, About Excel objects
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
Using Visual Basic
Language structure, Using variables, Declaring variables, Data types, Making decisions, If statements, Looping structures
Assigning a macro to the Ribbon, Assigning a macro to the QuickAccess Toolbar, Assigning macros to other objects, Built-in dialogue boxes, Using form controls