<br /><br /><span class="GingerNoCheckStart"></span><span class="GingerNoCheckStart"></span><span class="GingerNoCheckStart"></span><span class="GingerNoCheckEnd"></span><span class="GingerNoCheckEnd"></span><br><div><br></div><div><br></div><div><div>Excel 2002 Power</div><div>Programming with VBA</div></div><div><br></div><div><div>John Walkenbach</div><div>M&amp;T Books</div><div>An imprint of Hungry Minds, Inc.</div><div>New York, NY ✦ Cleveland, OH ✦ Indianapolis, IN</div></div><div><br></div><div><div>How This Book Is Organized</div><div>The chapters of this book are grouped into seven main parts. In addition, I’ve</div><div>included a few appendixes that provide supplemental information.</div><div>Part I: Some Essential Background</div><div>In this part, I set the stage for the rest of the book. Chapter 1 presents a brief history</div><div>of spreadsheets so that you can see how Excel fits into the big picture. In Chapter 2,</div><div>I offer a conceptual overview of Excel 2002 — quite useful for experienced spreadsheet users who are switching to Excel. In Chapter 3, I cover the essentials of&nbsp;</div><div>formulas, including some clever techniques that may be new to you. Chapter 4&nbsp;</div><div>covers the ins and outs of the various files used and generated by Excel.</div></div><div><br></div><div><div>Part II: Excel Application Development</div><div>This part consists of just two chapters. In Chapter 5, I broadly discuss the concept</div><div>of a spreadsheet application. Chapter 6 goes into more detail and covers the steps</div><div>typically involved in a spreadsheet application development project.</div><div>Part III: Understanding Visual Basic for Applications</div><div>Chapters 7 through 11 make up Part III, and these chapters include everything you</div><div>need to know to learn VBA. In this part, I introduce you to VBA, provide programming fundamentals, and detail how to develop VBA subroutines and functions.</div><div>Chapter 11 contains tons of useful VBA examples.</div><div>Part IV: Working with UserForms</div><div>The four chapters in this part cover custom dialog boxes (also known as UserForms).</div><div>Chapter 12 presents some built-in alternatives to creating custom UserForms.</div><div>Chapter 13 provides an introduction to UserForms and the various controls you</div><div>can use. Chapters 14 and 15 present many examples of custom dialog boxes, ranging from basic to advanced.</div><div>Part V: Advanced Programming Techniques</div><div>Part V covers additional techniques that are often considered advanced. The first</div><div>three chapters discuss how to develop utilities and how to use VBA to work with</div><div>pivot tables and charts. Chapter 19 covers the topic of event-handling, which</div><div>enables you to execute procedures automatically when certain events occur.</div><div>Chapter 20 discusses various techniques that you can use to interact with other</div><div>applications (such as Word). Chapter 21 concludes Part V with an in-depth discussion of creating add-ins.</div><div>Part VI: Developing Applications</div><div>The chapters in Part VI deal with important elements of creating user-oriented</div><div>applications. Chapters 22 and 23 provide information on creating custom toolbars</div><div>and menus. Chapter 24 presents several different ways to provide online help for</div><div>your applications. In Chapter 25, I present some basic information about developing user-oriented applications, and I describe such an application in detail.</div><div>Part VII: Other Topics</div><div>The five chapters in Part VII cover additional topics that you may find helpful.</div><div>Chapter 26 presents information regarding compatibility. In Chapter 27, I discuss</div><div>various ways to use VBA to work with files. In Chapter 28, I explain how to use VBA</div><div>4799-2 FM.F &nbsp;6/11/01 &nbsp;1:12 PM &nbsp;Page xiiixiv Preface</div><div>to manipulate Visual Basic components such as UserForms and modules. Chapter</div><div>29 covers the topic of class modules. I finish the part with a useful chapter that</div><div>answers many common questions about Excel programming.</div><div>Appendixes</div><div>Five appendixes round out the book. Appendix A contains useful information about</div><div>Excel resources online. Appendix B is a reference guide to all of VBA’s keywords</div><div>(statements and functions). I explain VBA error codes in Appendix C, and Appendix</div><div>D is a handy ANSI code reference chart. The final appendix describes the files available on the companion CD-ROM</div></div><span class="GingerNoCheckEnd"></span>