Microsoft Excel VBA Programming for the Absolute Beginner, Second Edition

  • 7h 37m
  • Duane Birnbaum
  • Cengage Course PTR
  • 2005

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 began programming in graduate school, where he wrote custom software for interfacing the electronic equipment required for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry in 1991, he has worked as a post-doctoral and research scientist in academia and industry while continuing to teach on a part-time basis. He has been teaching courses in introductory programming, database design, and data analysis in the Computer Science department at Indiana University/Purdue University at Indianapolis for the past 8 years.

In this Book

  • Visual Basic for Applications with Excel
  • Beginning Programs with VBA
  • Procedures and Conditions
  • Loops and Arrays
  • Basic Excel Objects
  • VBA UserForms and Additional Controls
  • Error Handling, Debugging, and Basic File I/O
  • Using XML with Excel-VBA Projects
  • Excel Charts
  • VBA Shapes