Main features:
- Developed on a professional basis and Drawn from 'real world' experience.
- Has five Workbook examples with the 20 lessons. Each lesson is between 5 and 10 Word Document pages long.
- Lesson 10 has Time Saving Microsoft Excel Solutions. It is freeware and a downloadable book in Windows help file format.
- BASIC COURSE OUTLINE: The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects, Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars, 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 Worksheet Functions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs. Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.
- User Forms Introduction, Filling User Form 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 ReEdit Control, Finding the Active Control, Creating Controls at Runtime.
|
