Publisher's Synopsis
Targeted at experienced Microsoft Excel 2000 users who are looking for ways to become more productive through the customization and automation of their spreadsheets. This book assumes that you already know how to create and manipulate Excel spreadsheets using the mouse and keyboard, and are interested in learning how to communicate with Excel in its powerful built-in language - Visual Basic for Applications (VBA).;With this book in your hands, you should discover easy ways to control Microsoft Excel programmatically. The book consists of 13 chapters that progressively teach you the basics of delegating worksheet tasks to Excel. Following a step-by-step method, you quickly gain the working knowledge of Excel VBA. "Learn MS Excel 2000 VBA Programming" leads you through the process of creating Visual Basic procedures from start to finish. Along the way, you will find detailed and practical "how-to" examples and illustrations. Want to know how to open a new worksheet without using the menu? Or, would you like to create a custom, fully automated form to gather data and store the results in a spreadsheet? Bringing this kind of automating power to your Microsoft Excel spreadsheets and making Excel do all sorts of things for you is easy with Learn MS Excel 2000 VBA Programming. The book aims to make you feel comfortable in the programming environment without forcing you to become a spreadsheet developer.