Excel® 2007 VBA Programming FOR DUMmIES by John Walkenbach & Revised by Jan Karel Pieterse

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

Download
http://uploading.com/files/GBJTK7RM/booktraining.net__MS-Excel_2007_VBA_Programming_For_Dummies.pdf.html

http://rapidshare.com/files/213591610/MS-Excel_2007_VBA_Programming_For_Dummies.pdf
Password default : booktraining.net