Synopses & Reviews
Written specifically with the beginner in mind, "Microsoft Excel VBA for the Absolute Beginner, Second Edition" is the follow up to the most successful and best selling title in the Absolute Beginner series. The book contains completely updated information written for the current version of Excel, Excel 2003. ?Microsoft Excel VBA for the Absolute Beginner, Second Edition,? is geared towards both students taking introductory programming courses, as well as professionals who frequently use spreadsheets and want to expand their knowledge of the capabilities of Excel by writing their own programs. In recent years, programming has experienced a surge unlike any other technical skill, due to both advancements in technology and the declining cost of computer hardware and software. This boom has created a need for more programmers and this book teaches programming using a very popular software package, making it perfect for new programmers. ?Microsoft Excel VBA for the Absolute Beginner, Second Edition,? uses the Excel VBA language to provide readers with an introduction to programming. Concentrating on introductory programming topics and good programming practices, the book uses the VBA Excel language and the creation of simple games to teach these topics and practices.
About the Author
Duane Birnbaum received a Ph.D from the University of California, Riverside in 1991 in physical chemistry. He works at Biogel Technology as a research scientist and has authored numerous scientific articles in the areas of chemical physics, biochemistry, and chemical engineering. He began teaching part-time in the computer science department of Indiana University - Purdue University at Indianapolis in 1997, focusing on an introductory course in data analysis with an emphasis on using the tools in spreadsheet applications. Duane lives in Indianapolis, Indiana.
Table of Contents
Introduction 1. Visual Basic for Applications with Excel 2. Beginning Programs with VBA 3. Procedures and Conditions 4. Loops and Arrays 5. Basic Excel Objects 6. Enhancing VBA Programs: Adding Multimedia and Intelligence 7. User Forms and Additional Controls 8. Data Access, File I/O, Error Handling, and Debugging 9. Excel Charts 10. VBA Shapes