VBA & Excel - VBA & Excel Barry L. Nelson IEMS...

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

View Full Document Right Arrow Icon
Barry L. Nelson IEMS 465 Fall Quarter 2003
Background image of page 1

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

View Full DocumentRight Arrow Icon
VBA Is a significant subset of the stand-alone Visual Basic programming language It is integrated into Microsoft Office applications (and others, like Arena) It is the macro language of Excel You can add Forms for dialog boxes with user Classes for object definitions Modules containing procedures
Background image of page 2
Accessing VBA in Excel Tools Macros Visual Basic Editor Enter VBA through the navigation buttons in the top toolbars VBA Design Mode Visual Basic Editor Design mode is the time during which no code from the project is running and events from Excel or project will not execute. You can leave design mode by executing a macro or using the Immediate window.
Background image of page 3

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

View Full DocumentRight Arrow Icon
VB Edit Window Project Explorer Property Inspector Code Window Edit Window Options
Background image of page 4
Variables Declare by Dim Better to use Data Types: Dim amount As Double Dim year As Integer Dim name As String Other data types: Boolean , Byte , Currency , Date Default (no type) is Variant
Background image of page 5

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

View Full DocumentRight Arrow Icon
Variable (cont’d.) % - integer ! - single # - double @ currency $ - string anIntegerValue% =3, aString$ = "hallo"
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

VBA & Excel - VBA & Excel Barry L. Nelson IEMS...

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

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