Excel Programming

About the Author Jinjer Simon has been actively involved in the computer industry for the past 17 years. Her involvement in the industry has included programming, providing software technical support, training end--users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Windows CE For Dummies and Windows CE 2 For Dummies. Jinjer and her husband live in Coppell, Texas with their two children. She currently works as a consultant for MillenniSoft, Inc., providing Web site development and online documentation development.

How to Use this Book. 1. Getting Started with Excel Macros. 2. Using the Visual Basic Editor. 3. VBA Programming Basics. 4. Working with the Excel Object Model. 5. Using Variables and Arrays. 6. Adding Control Statements. 7. Using Built--In Functions and Statements. 8. Debugging Macros. 9. Working with Other Workbooks and Files. 10. Working with Worksheets. 11. Defining Ranges. 12. Working with Cells. 13. Customizing Dialog Boxes, Menus, and Toolbars. 14. Working with Charts. 15. Automating Procedures with Excel Events. Appendix A: VBA Quick Reference. VBA and Excel Object Model Quick Reference. Appendix B: About the CD--ROM. What's on the CD--ROM. Using the E--Version of the Book. Hungry Minds, Inc. End--User License Agreement.