Excel Programming
Your Visual Blueprint for Creating Interactive Spreadsheets
Published on 15. November 2001
Book
Mixed media product
XIV, 338 pages
978-0-7645-3646-5 (ISBN)
Description
Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 100 tasks, including complete coverage of macros - with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation.
More details
Other editions
New editions
Book
09/2005
2nd Edition
Hungry Minds Inc,U.S.
€20.90
Article exhausted; check for reprint
Persons
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.
Content
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.