Page 9 - Excel Progamming Weekend Crash Course

540629 FM.qxd 9/2/03 4:10 PM Page vi

vi Preface

to provide a convenient breaking point to help you in pacing your progress. At the end of
each part, you’ll find additional questions related to that part’s session topics. The answers
for the part review questions are provided in Appendix A.

Part I: Friday Evening
The first session provides an introduction to programming with Excel, including an overview
of many of the advantages. You’ll also find some basic information about programming in
this session.
The second session teaches you how to use the VBA Code Editor. This tool is part of the
Excel installation, and you use it to create, test, and run your programs.
Session 3 deals with the Excel Object Model. This is the set of tools that the Excel appli-
cation makes available for you to use in your programs.
Session 4 introduces you to the VBA language, your primary tool for writing programs.

Part II: Saturday Morning
Sessions 5 through 9 cover the VBA language. You need a good knowledge of the VBA lan-
guage’s elements and syntax to write programs. This includes learning about operators, con-
trol constructs, procedures, and modules, as well as how to work with dates, times, and
text. The final session in this part, Session 10, shows you how to work with Excel’s ranges
and selections.

Part III: Saturday Afternoon

Sessions 11 through 14 cover the fundamentals of controlling Excel through VBA code.
You’ll learn how to work with columns, rows, and cells; how to program with custom formu-
las and built-in functions; and how to format a worksheet. The last two sessions deal with
find and replace operations and creating custom toolbars.

Part IV: Saturday Evening

Sessions 17 and 18 show you how to use Excel’s powerful charting capabilities in your pro-
grams. Then Sessions 19 and 20 present the basics of creating custom dialog boxes for your
programs with Excel’s user forms.

Part V: Sunday Morning
Sessions 21 and 22 finish the coverage of user forms, including a complete example.
Sessions 23 through 26 deal with the topics of Excel events, security considerations,
and debugging distributing an application, and creating custom classes.