- Cover
- Cover
- Introduction
- Part I: Getting Started with Excel VBA Programming
- Part II: How VBA Works with Excel
- Part III: Programming Concepts
- Chapter 7: Essential VBA Language Elements
- Chapter 8: Working with Range Objects
- Chapter 9: Using VBA and Worksheet Functions
- Chapter 10: Controlling Program Flow and Making Decisions
- Chapter 11: Automatic Procedures and Events
- Chapter 12: Error-Handling Techniques
- Chapter 13: Bug Extermination Techniques
- Chapter 14: VBA Programming Examples
- Part IV: Communicating with Your Users
- Part V: Putting It All Together
- Part VI: The Part of Tens
- Chapter 22: Ten VBA Questions (and Answers)
- Chapter 23: (Almost) Ten Excel Resources
- Chapter 24: Ten VBA Do’s and Don’ts
- Do Declare All Variables
- Don’t Confuse Passwords with Security
- Do Clean Up Your Code
- Don’t Put Everything in One Procedure
- Do Consider Other Software
- Don’t Assume That Everyone Enables Macros
- Do Get in the Habit of Experimenting
- Don’t Assume That Your Code Will Work with Other Excel Versions
- Do Keep Your Users in Mind
- Don’t Forget About Backups
- About the Author
- Cheat Sheet
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Part VI
The Part of Tens
Check out an additional Part of Tens chapter online at www.dummies.com/extras/vbaprogramming.
In this part …
Discover the answers to common VBA questions.
Expand your knowledge with Excel resources.
Find out what you should and shouldn’t do in Excel VBA.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.