ITM 215 Class 26 Apr 29

ITM 215 Class 26 Apr 29 - ITM 215: Computer Applications in...

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

View Full Document Right Arrow Icon
ITM 215: Computer Applications in Business
Background image of page 1

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

View Full DocumentRight Arrow Icon
8/22/2007 New Perspectives on Objectives Create a macro using the macro recorder Work with the Project Explorer and Properties window of the VBA Editor Edit a sub procedure Run a sub procedure Work with VBA objects, properties, and methods 22
Background image of page 2
8/22/2007 New Perspectives on Objectives Create and run If-Then control structures Work with comparison and logical operators Create message boxes/input boxes Customize the Quick Access Toolbar Customize Excel 33
Background image of page 3

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

View Full DocumentRight Arrow Icon
8/22/2007 New Perspectives on Developing an Excel If the Excel Developer tab is not on the Ribbon, click the Office Button , click the Excel Options button, click Popular in the Excel Options dialog box (if necessary), click the Show Developer tab in the Ribbon check box to insert a check mark, and then click the OK button 44
Background image of page 4
8/22/2007 New Perspectives on Visual Basic for Applications VBA is a subset of Visual Basic Macros are converted to VBA programs Programs known as procedures Also called subroutines ; thus the word Sub at the beginning of the macro and End Sub at the end of the macro. VBA allows you to modify macros
Background image of page 5

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

View Full DocumentRight Arrow Icon
8/22/2007 New Perspectives on Syntax The rules governing the formation of statements in a programming language.
Background image of page 6
8/22/2007 New Perspectives on Procedures Procedures are VBA code statements that perform a specific task Can be created in one of two ways: Entering the code directly in the VBA editor Using the macro recorder to capture Excel commands and convert them to VBA
Background image of page 7

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

View Full DocumentRight Arrow Icon
8/22/2007 New Perspectives on Traditional Programming Is Executed Sequentially , Beginning with the First Line of Code and Continuing in Order through the Remainder of
Background image of page 8
8/22/2007 New Perspectives on Visual Basic Programming Is Event Driven , the Order in Which the Procedures are Executed Depends on the Events That Occur Event Oriented
Background image of page 9

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

View Full DocumentRight Arrow Icon
8/22/2007 New Perspectives on Events Open a Workbook Close a Workbook Click a Button Enter Data in Form
Background image of page 10
8/22/2007 New Perspectives on Introduction to Macros Macro recorder stores Excel commands Commands are written in Visual Basic for Applications Macros can be displayed with Visual Basic Editor ( VBE ) Use VBE to create, edit, run, and debug (fix) Excel macros
Background image of page 11

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

View Full DocumentRight Arrow Icon
8/22/2007 New Perspectives on Macro Statements Sub statement, followed by the name of the macro Sub is short for subroutine
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/08/2010 for the course BITM 215 taught by Professor Ross during the Spring '08 term at SUNY Albany.

Page1 / 53

ITM 215 Class 26 Apr 29 - ITM 215: Computer Applications in...

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

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