Contents at a Glance
Introduction .........1
Part I: Introducing VBA ......9
Chapter 1: What Is VBA?........11
Chapter 2: Jumping Right In.......21
Part II: How VBA Works with Excel....33
Chapter 3: Working In the Visual Basic Editor........35
Chapter 4: Introducing the Excel Object Model ........53
Chapter 5: VBA Sub and Function Procedures ........67
Chapter 6: Using the Excel Macro Recorder .........79
Part III: Programming Concepts.....91
Chapter 7: Essential VBA Language Elements ........93
Chapter 8: Working with Range Objects.........113
Chapter 9: Using VBA and Worksheet Functions .......125
Chapter 10: Controlling Program Flow and Making Decisions .....139
Chapter 11: Automatic Procedures and Events........157
Chapter 12: Error-Handling Techniques.........177
Chapter 13: Bug Extermination Techniques ........191
Chapter 14: VBA Programming Examples .........203
Part IV: Communicating with Your Users ...221
Chapter 15: Simple Dialog Boxes......223
Chapter 16: UserForm Basics......239
Chapter 17: Using UserForm Controls .....255
Chapter 18: UserForm Techniques and Tricks ........275
Chapter 19: Accessing Your Macros Through the User Interface ....299
Part V: Putting It All Together .....315
Chapter 20: Creating Worksheet Functions and Living to Tell about It...317
Chapter 21: Creating Excel Add-Ins.....333
Part VI: The Part of Tens ......345
Chapter 22: Ten VBA Questions (And Answers) .......347
Chapter 23: (Almost) Ten Excel Resources.........351
Index .........355
http://rapidshare.com/files/213591610/MS-Excel_2007_VBA_Programming_For_Dummies.pdf
Password default : wpspot.info
