|
|
Excel VBA and Excel UserForms Training
-
Version
1
No special software is needed to use - just download,
run ,and open Excel. Access from the Excel Tools menu
by clicking on the new menu item. Time savings Excel
solutions are always just a click away - you even save
time by avoiding fruitless Internet searches!
BASIC COURSE OUTLINE:
The Fundamentals of Excel VBA, The Visual Basic
Editor, Objects and Properties, Excel Objects , Object
Hierarchy, Application, Workbook, Worksheet, Range,
CommandBars, Variables and Constants, Data types,
Variable Levels, Declaring Variables, Constants,
Loops, Types of Loops, Loop Pitfalls, Effective
Decision Making, If/And/Or, Select Case, Dates and
Times, Workbook and Worksheet Events, Debugging and
Error Handling, Prevention, Good Habits, Runtime
Errors, Excel WorksheetFunctions in VBA, Specific
Examples, Excels Built-In Features, User Defined
Functions, Good vs Bad, Arguments, Calculation,
Controls, ActiveX, Control Toolbox, Control
Properties, Control Parent.
UserForms Introduction, Filling UserForm Controls,
Putting Data into our Controls, When to put Data into
our Control, Filling a ListBox and/or ComboBox using
Loops, Multi-Page Control, Creating a wizard using the
Multi-Page Control, Validating the User Inputs, Some
Useful Methods and Functions, When to apply
Validation, Control Events, Which Controls to use and
When, Parsing Control Values back to a Spreadsheet,
Parsing range values to the UserForm Controls, Option
Buttons and Checkboxes in Detail, True or False,
Creating Template Controls, Using the RefEdit Control,
Finding the Active Control, Creating Controls at
Runtime.
WHY USE US FOR EXCEL TRAINING?
Like all our products and services, OzGrid training
will cater to your specific needs. OzGrid specializes
in Microsoft Excel, this is all we do! Over time we
have focused our business directly towards Excel.
Other training companies will offer training in many
different Applications, and while they may supply
information from good trainers it is very unlikely the
trainers will know Excel to the extent we do! Remember
we develop Excel spreadsheets in our day-to-day
business so we know what you will encounter in your
day-to-day use of Excel. We are not just Excel
teachers, but also Excel developers!
|