Page 42 - Excel Progamming Weekend Crash Course
P. 42

d540629 ch02.qxd  9/2/03  9:27 AM  Page 17


                                                                          SESSION



                                                                                 2










                                                    The VBA Code Editor










               Session Checklist

               ✔ How VBA projects are organized
               ✔ Using the Project Explorer
               ✔ Sharing code between projects
               ✔ Using the editing tools

               ✔ Working in the Property Window
               ✔ Using macros in programming
               ✔ Using online help



                    he VBA Editor is the tool you use to create and edit your VBA programs, but it is much
                    more than a simple editor. It also enables you to run and debug your programs, keep
               T your code organized, deal with code security, design user input forms, and view online
               help information.
                          Some functions of the Editor are covered in other sessions, specifically secu-
                          rity (Session 24), debugging (Session 25), and user forms (Sessions 19
                 Cross-Ref  through 21).


               Code and Project Organization

               At the lowest level, VBA code is organized into units called procedures (or sometimes sub
               procedures). A procedure contains the following:
   37   38   39   40   41   42   43   44   45   46   47