- 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 V
Putting It All Together
Discover how to use VBA code to display numbers as words at www.dummies.com/extras/excelvbaprogramming.
In this part …
Find out why you might want to create custom worksheet functions.
Make your custom functions work just like Excel's built-in functions.
Discover Excel add-ins.
Create simple add-ins.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.