ch. 13 introduction to macros and vba

ch. 13 introduction to macros and vba - (Visual Basic for...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style (Visual Basic for Applications)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Supplemental Reading In addition to Chapter 13: Chapter 7 “Read” entire chapter (10 pages) “Study” pages 286-289 Goal: Understand the 3 types of programming structures: (“testable” material) Sequence Decision
Background image of page 2
What is VBA? A variation of Visual Basic 6.0 (rather than VB.NET or newer versions) Not a standalone programming language Must be programmed within a host application, such as Microsoft Office products (Excel, Access, Word, Outlook)
Background image of page 3

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

View Full DocumentRight Arrow Icon
What is a macro? A set of user actions (such as mouse clicks and keystrokes) that are captured and recorded automatically by the application (Excel, Word, etc.) in VBA. The actions are repeated by “running” the macro, which executes the computer code. Macros can also be written directly into VBA
Background image of page 4
Sample Applications of Excel Macros A macro that updates inventory value as new items are received. Also adds new inventory items received
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 15

ch. 13 introduction to macros and vba - (Visual Basic for...

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

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