VBA in Excel
For EES&OR 237
By Anton A. Rowe
Visual Basic For Applications In Excel
EES&OR 237, Fall 1998
Anton A. Rowe, Episoft, Inc.
INTRODUCTION .................................................................................................................................................. 2
ADDITIONAL READING MATERIALS.............................................................................................................. 3
LESSON 0: THE BASICS ...................................................................................................................................... 4
WHAT IS VISUAL BASIC? ........................................................................................................................................ 4
WHAT CAN I DO WITH VISUAL BASIC? ..................................................................................................................... 4
HOW DO I ACCESS VISUAL BASIC? .......................................................................................................................... 4
YOUR FIRST SUBROUTINE....................................................................................................................................... 5
YOUR FIRST FUNCTION........................................................................................................................................... 6
PUTTING THE PIECES TOGETHER ............................................................................................................................. 6
PASSING ARGUMENTS ............................................................................................................................................ 6
FUNDAMENTAL PROGRAMMING BUILDING BLOCKS.................................................................................................... 7
USING VISUAL BASIC ONLINE HELP .................................................................................................
excel vba 来自淘豆网m.daumloan.com转载请标明出处.
