Professional

Microsoft® Excel® VBA Programming for the Absolute Beginner, 3rd Edition

  • Duane Birnbaum
  • Michael Vine
  • ISBN-10: 1598633945  |  ISBN-13: 9781598633948
  • 400 Pages
  • Previous Editions: 2005, 2002
  • © 2007 | Published
  • List Price = $ 29.99
  • For quantity discounts, Contact your Representative
  • For single copy purchases, visit CengageBrain.com

About

Overview

If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming through simple game creation. Microsoft Excel VBA Programming for the Absolute Beginner, Third Edition provides you with the skills that you need for more practical Excel VBA programming applications and shows you how to put these skills to use in real-world scenarios. Best of all, by the time you finish the book, you will be able to apply the basic principles you've learned to the next programming language you tackle.

Features and Benefits

  • No previous Excel or programming experience is required.
  • The book has been fully updated to cover the current version of Excel 2007.
  • Teaches programming techniques the fun way � through simple, game-based programs that run in Excel.
  • Teaches you to write useful applications for data analysis in Excel including Workbooks, Worksheets, Ranges, Formulas, Charts, Menus and Toolbars, and MS Access Databases.
  • Companion website available here: http://www.delmarlearning.com/companions/index.asp?isbn=1598633945

Table of Contents

Chapter 1 – Visual Basic for Applications with Excel
Chapter 2 – Beginning Programs with VBA
Chapter 3 – Procedures and Conditions
Chapter 4 – Loops and Arrays
Chapter 5 – Basic Excel Objects
Chapter 6 – Enhancing VBA Programs: Adding Multimedia and Intelligence
Chapter 7 – UserForms and Additional Controls
Chapter 8 – Data Access, File I/O, Error Handling, and Debugging
Chapter 9 – Excel Charts
Chapter 10 – VBA Shapes

Meet the Author

Author Bio

Duane Birnbaum

Duane Birnbaum began programming in graduate school, where he wrote custom software for interfacing the various electronic devices require for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry, he has worked in academia and the biotech industry while continually teaching on a part-time basis. He has been serving as a part-time lecturer in computer science at Indiana University/Purdue University Indianapolis for seven years teaching courses in programming, data analysis, and database design.

Michael Vine

Michael Vine is a senior IT professional who specializes in data warehousing and business intelligence. Beyond corporate life, he has taught computer science classes at the university and college level and authored many software programming books.