Birnbaum D. Microsoft Excel VBA Programming for the Absolute Beginner

Premier Press (Course Technology), 2002. — 425 p.Рассматривается версия MS Office 2003.The goal of this book is to provide a solid introduction to the VBA programming language and show how it can be applied to create practical applications for Excel. The book is targeted to intermediate and advanced programmers; however, since VBA is arguably the easiest language out there to learn, beginning programmers with a strong Excel background should also be reasonably comfortable with this book.Conents:
Visual Basic for Applications with Excel.
Project: Colorful Header.
The VBA Integrated Development Environment (IDE).
Getting to the IDE from Excel.
Components of the IDE.
Programming Components within Excel.
Macro Selection.
The Visual Basic Toolbar.
Getting Help with VBA.
Excel Help.
VBA Help.
Installing VBA Help Files.
Constructing the Colorful Header Program.
Chapter Summary.
Beginning Programs with VBA.
Project: Time of Your Life.
Variables, Data Types, and Constants.
Declaring Variables.
Data Types.
Constants.
Simple Input and Output with VBA.
Collecting User Input with InputBox().
Output with MsgBox().
Manipulating Strings with VBA Functions.
Fun with Strings.
Constructing the Time of Your Life Program.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
Procedures and Conditions.
Project: Poker Dice.
VBA Procedures.
Event Procedures.
Sub Procedures.
Function Procedures.
Logical Operators in VBA.
Conditionals and Branching.
Constructing the Poker Dice Program.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
Loops and Arrays.
Project: The Math Game.
Looping with VBA.
Do Loops.
For Loops.
Input Validation.
Validation with the InputBox() Function.
Validation with a Spreadsheet Cell.
Arrays.
One-Dimensional Arrays.
Multi-Dimensional Arrays.
Dynamic Arrays.
Programming Formulas into Worksheet Cells.
A1 Style References.
R1C1 Style References.
Chapter Project: Math Game.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
Basic Excel Objects.
Project: Battlecell.
VBA and OOP.
Objects Defined.
VBA Collection Objects.
The Object Browser.
Top-Level Excel Objects.
The Application Object.
The Workbook and Window Objects.
The Worksheet Object.
The Range Object.
Working with Objects.
Chapter Project: Battlecell.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
Enhancing VBA Programs: Adding Multimedia and Intelligence.
Project: Enhanced Battlecell.
Adding Multimedia to a Program.
Animation in VBA.
Sound in VBA.
Simulating Intelligence in Programs.
Chapter Project: Enhanced Battlecell.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
UserForms and Additional Controls.
Project: Blackjack.
UserForms.
Adding a UserForm to a Project.
Components of the UserForm Object.
Adding ActiveX Controls to a UserForm.
Showing and Hiding UserForms.
Modal Forms.
Custom Dialog Boxes with UserForms.
Chapter Project: Blackjack.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
Data Access, File I/O, Error Handling, and Debugging.
Project: Word Find.
File Input and Output (I/O).
Using VBA File I/O Methods.
Error Handling.
Using the On Error Statement.
Debugging.
Break Mode.
The Immediate Window.
The Watch Window.
The Locals Window.
Chapter Project: Word Find.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
Excel Charts.
Project: The Alienated Game.
The Chart Object.
Accessing Existing Charts.
Manipulating Charts.
Creating Charts.
Chart Events.
Chapter Project: The Alienated Game.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
VBA Shapes.
Project: Excetris.
The Shapes Collection and Shape Objects.
Manipulating a Shape Object.
The ShapeRange Collection Object.
Activating Shape Objects.
The OLEObjects Collection.
Chapter Project: Excetris.
Project Statement.
Project Tools.
Project Algorithm.
Adding the Code.
Chapter Summary.
A Final Word.