Excel 2007 VBA Programming For Dummies

 关于VBA 的傻瓜书。据说dummies 都翻译成傻瓜书。PDF版本。

177994.pdf
大小:(9.45 MB)

只需: 20 个论坛币  马上下载

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