![]() ![]() These classes run in a computer lab and you do not need to bring your own device. Face-to-face, presenter-taught training in a computer lab (Windows environment).You should also have basic knowledge of Microsoft Excel and programming principles and practice. It is recommended that you are comfortable with the learning outcomes equivalent to our Microsoft Excel VBA Course: Introduction. Truly automating Excel with Event Proceduresĭesigned for users who wish to learn how to use the inbuilt programming language in Microsoft Excel to enhance their worksheets and automate processes.Making a form interact with spreadsheets through the setting of properties and through code.Building a form with controls including textboxes, dropdown lists, option buttons and command buttons.A complete guide to error handling in VBA (telling code what to do if it breaks).Referencing (using) procedures you have written in other Workbooks. ![]() Referencing (using) libraries of code exposed by other systems (Word, Outlook, ADO etc.).Endless loops and how to deal with them.More repetition structures in VBA including when to nest loops.When to use Excel interface functions in VBA code.More Constants and Enumerations in the Excel Object Model.Working with the Workbooks, Worksheets and Cells Collections.Collection Object common properties and methods.Stopping Screen Flicker produced by recorded Macros.The Range Property and selecting Ranges.Declaring your own identifiers of types in the object model.Using existing identifiers methods and properties.The purpose and structure of all object-oriented programming languages.Classes, Objects and Variables vs Types and Identifiers.The differences between Value/Primitive Types and Reference Types.Reference types and the VBA Excel Object Model More on Enumerations and Constants (we can’t ignore them, they are everywhere).The Message Box as a Statement and Function.Guidelines for Module Level and Global Level Variables.VBA Functions to check the data type of an identifier.Functions to convert one type to another type.Working with the VBA data type Variant and Date.Implicit variable declaration vs enforcing explicit declaration of variables in your code with Option Explicit.Passing Variables to other procedures by reference or by value and when to use those techniques.Hiding a Public Sub from the Excel interface.Return types of functions and parameter types.Choosing procedure types and the “rules” for choosing the correct procedure type.Writing algorithms that affect the Excel Object Model.Editing how watched variables/identifiers are reported on.The Locals and Watch windows, and using them interactively.Printing to the debug window and using it to interact with your variable values.This course will provide a brief recap of the course material covered in Microsoft Excel VBA: Introduction and then cover the following topics: Complete debugging write a variety of error handling routines and complete your proficiency in debugging.create procedures that execute automatically in response to user manipulation of Excel (Event Procedures).learn more repetition structures in VBA and the circumstances in which to apply them and nest repetition structures.divide and conquer complex logic with the implementation of “helper” procedures.create safer code using VBA's procedure and variable/object/identifier scopes.create a custom form complete with controls and event procedures.explore the pattern of Microsoft Excel object model (types, properties and methods) and manipule it with VBA.create, read and improve recorded macro code.This three-day advanced course shows you how to use a combination of the Microsoft Excel Object Model and VBA to improve your productivity, adding power and flexibility to spreadsheets by creating user-defined functions and macros.īasic knowledge of Microsoft Excel is required, and all technical terms and concepts will be explained simply.īy the end of this course, you should be able to:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |