Lec02_IE212_IntroVBA_W16_stds-1.ppt - IE 212 Computational Methods for Industrial Engineering Lecture Notes#2 The Visual Basic Editor The Visual Basic

Lec02_IE212_IntroVBA_W16_stds-1.ppt - IE 212 Computational...

This preview shows page 1 - 14 out of 43 pages.

Marc Christman Fall 2016 Lecture Notes #2: The Visual Basic Editor The Visual Basic for Applications Programming Language IE 212: Computational Methods for Industrial Engineering
Image of page 1
Outline In this module, the following topics will be covered: The basics of the Visual Basic Editor (VBE) environment Project Explorer Window Properties Window Code Window Introduction to the Excel Visual Basic for Applications (VBA) programming language The Excel object model The difference between a property, a method, and an event Fundamental skills for reading, understanding, and writing basic Excel VBA code Basic user interface development Assigning sub procedures to shapes (i.e., buttons) 2
Image of page 2
3 The Visual Basic Editor (VBE)
Image of page 3
The Visual Basic Editor The Visual Basic Editor (VBE) is the environment in which you work with Excel VBA code Excel and the VBE have separate windows You can toggle between as needed by pressing Alt+F11 4 Excel VBE
Image of page 4
The Visual Basic Editor (cont.) Access the VBE through the Developer Ribbon (Excel 2013) 1) Open Excel 2010 and click on the green tab labeled “File” 2) Click on “Options” (the window “Excel Options” will appear) 3) Click on “Customize Ribbon” 4) Make sure the entry in the combo box labeled “Customize the Ribbon” reads “Main Tabs” 5) Select the option “Developer” 6) Click OK 5
Image of page 5
The Visual Basic Editor (cont.) There are three main windows in the VBE Project Explorer Window Properties Window Code Window Two additional windows in the VBE are mainly used for debugging Immediate Window Watch Window VBE Toolbars Standard toolbar 6
Image of page 6
The Visual Basic Editor (cont.) The VBE’s windows 7 Project Explorer Properties Window Code Window Watch Window Immediate Window
Image of page 7
Project Explorer Lists all projects in any open workbook Each workbook has a project, and each project can have several parts Objects (e.g., workbook and worksheets) Modules Forms In the VBE, you can use Insert > Module to add a new module to the current project Can also use icon from standard toolbar 8
Image of page 8
Properties Window Contains detailed information about any selected part of a project in the Project Explorer Some basic naming and formatting properties can be modified for worksheets and workbooks Properties are very important for user forms Formatting Position Picture Scrolling Behavior 9
Image of page 9
Code Window Displays the VBA code for the highlighted part of a project in the Project Explorer When macros are recorded , VBA code is simultaneously created and can be edited in the VBE You will write your own code in this window, once you are more familiar with Excel VBA 10
Image of page 10
Immediate and Watch Windows Both of these windows are used for debugging The Immediate Window allows you to enter code that is executed immediately As long as the syntax is correct The Watch Window displays values of inserted variables Use the View menu option to view or hide any window 11
Image of page 11
12 The Excel VBA Programming Language
Image of page 12
Visual Basic for Applications Visual Basic for Applications (VBA) brings a dynamic
Image of page 13
Image of page 14

You've reached the end of your free preview.

Want to read all 43 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture