58.

V

validation, checking input values via TestInput macro, 145-46

Value property

OptionButton object, 229

Range object, 112-13

TextBox object, 232

variables

for enabling Auto List feature, 66-67

vs. functions, 164

naming, 137

overview, 164

in recorded macros, 33

static, 290

Variant type, 66

View Code button, 196

viewing macros, 7-9

views, worksheet

creating, 240-42

custom, 240-42

Summary view, 240-42

Visible property, 133

Visual Basic, 2. See also Visual Basic for Applications (VBA)

Visual Basic Editor. See also Object Browser

eliminating macro lines, 12-13

Project Explorer button, 247

stepping through macros, 29-32

viewing macros, 7-9

Visual Basic for Applications (VBA). See also Visual Basic Editor

Automation and, 2-3

dockable windows, 57

hiding, 4

relationship to Excel, 51

Visual Basic toolbar

hiding, 4

Record Macro button, 5-6

Run Macro button, 29

showing, 4

volatile functions, 168



Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net