发帖
雷达卡
关于VBA 的傻瓜书~~ Excel VBA Programming for Dummies 2010 适用于excel2007-2010
Contents at a Glance
Introduction ................................................................ 1
Part I: Introducing VBA ............................................. 11
Chapter 1: What Is VBA? .................................................................................................13
Chapter 2: Jumping Right In ...........................................................................................23
Part II: How VBA Works with Excel ............................. 35
Chapter 3: Working In the Visual Basic Editor .............................................................37
Chapter 4: Introducing the Excel Object Model ...........................................................55
Chapter 5: VBA Sub and Function Procedures ............................................................69
Chapter 6: Using the Excel Macro Recorder ................................................................81
Part III: Programming Concepts .................................. 93
Chapter 7: Essential VBA Language Elements ..............................................................95
Chapter 8: Working with Range Objects .....................................................................115
Chapter 9: Using VBA and Worksheet Functions.......................................................129
Chapter 10: Controlling Program Flow and Making Decisions.................................141
Chapter 11: Automatic Procedures and Events .........................................................161
Chapter 12: Error-Handling Techniques .....................................................................183
Chapter 13: Bug Extermination Techniques ...............................................................197
Chapter 14: VBA Programming Examples...................................................................211
Part IV: Communicating with Your Users ................... 233
Chapter 15: Simple Dialog Boxes .................................................................................235
Chapter 16: UserForm Basics .......................................................................................253
Chapter 17: Using UserForm Controls ........................................................................269
Chapter 18: UserForm Techniques and Tricks ..........................................................289
Chapter 19: Accessing Your Macros through the User Interface ............................313
Part V: Putting It All Together .................................. 331
Chapter 20: Creating Worksheet Functions — and Living to Tell about It .............333
Chapter 21: Creating Excel Add-Ins .............................................................................349
Part VI: The Part of Tens .......................................... 361
Chapter 22: Ten VBA Questions (And Answers) .......................................................363
Chapter 23: (Almost) Ten Excel Resources ................................................................367
Is This the Right Book?
Go to any large bookstore and you’ll find many Excel books (far too many,
as far as I’m concerned). A quick overview can help you decide whether this
book is really right for you. This book
✓ Is designed for intermediate to advanced Excel users who want to get up
to speed with Visual Basic for Applications (VBA) programming.
✓ Requires no previous programming experience.
✓ Covers the most commonly used commands.
✓ Is appropriate for Excel 2007 or Excel 2010.
✓ Just might make you crack a smile occasionally — it even has cartoons.
If you are using Excel 2000, XP, or 2003, this book is not for you. Excel 2007
and Excel 2010 are very different from previous versions. If you’re still using a
pre-2007 version of Excel, locate a book that is specific to that version.
京公网安备 11010802022788号
