Main features:
- Each lesson is between 5 and 10 Word Document pages long. The 10 lessons include five Workbook examples.
- Lesson 10 ,which is freeware, has Time Saving Microsoft Excel Solutions. It contains hundreds of solutions to Microsoft Excel problems and it is 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.
|