ENGR1412 VBA - Microsoft Visual Basic for Applications...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Microsoft V isual B asic for A pplications (VBA) Editor Project Window - Shows all objects available in any workbook. . . . By default this is the upper left hand internal window, which shows all available objects in each workbook open in MS-EXCEL. This window can be hidden from view, to turn it off you would click on the ‘x’ in the upper right-hand corner of the internal window, and to recover the window go to the “View” Menu and click on the “Project Explorer” option - about 2/3 rds down the list).
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Principle VBA Project Objects Each workbook may have a multiple number of three different types of objects. (1) Worksheets - The usual method of presentation of data and calculations in MS-EXCEL. The object we are all familiar with for interacting/calculations. (2) Modules - Modules are visual basic code windows where we can write two type of code: Function routines - which are codes where the value of a calculation itself is returned in the function’s name Function AreaCircle (sngRadius as Single) as Single
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/26/2011 for the course ENGR 1412 taught by Professor Staff during the Spring '08 term at Oklahoma State.

Page1 / 3

ENGR1412 VBA - Microsoft Visual Basic for Applications...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online