Index

V

validation rules, 340

variables

declaring, 86–88

defined, 86

global, 175

input and output, 90–92

local, 171

prefixes, 88

static, 176

types of, 87

See also constants; variants

variants, 89

See also variables

VBA, 63–64, 367

calling reports from, 246–247

converting macros into code, 37–38

Data Access Pages and, 327–328

equivalents of startup properties, 269–272

functions, 66

history of, 4, 64

and Microsoft Office, 368–373

modules, 65

naming conventions, 38–39

objects, 139–140

Options dialog box, 272–280

procedures, 65–66

SQL and, 157–160

VBA model, 64–66

working without, 30–33

VBA Editor, 9, 71–74, 114

Assert member, 196, 197

Auto Data Tips option, 131–132

Auto Indent/Tab Width option, 132

Auto List Members option, 129–130

Auto Quick Info option, 130–131

Auto Syntax Check option, 128–129

breakpoints, 193–196

Code command, 116

Code window, 72

Complete Word command, 115

creating a click procedure, 74–77

Debug toolbar, 117

Definition command, 116

Docking tab, 134

Edit menu, 115

Edit toolbar, 118

Editor Format tab, 133

Editor tab, 128–133

in Excel, 368–369

General tab, 133–134

help, 135–137

Immediate window, 72, 193–196

importing and exporting modules, 121

inserting and deleting modules, 119–121

List Constants command, 115

List Properties/Methods command, 115

Locals window, 196–198

Macros command, 116

menu shortcut, 116–117

Object Browser, 123–126

Object Browser command, 116

Object command, 116

Objects list box, 72, 73

opening, 113–115

Options command, 116

Options dialog box, 128–134

Parameter Info command, 115

Procedures list box, 72, 74

Project Explorer window, 72, 114, 118–119

Properties window, 72, 73, 122–123

Quick Info command, 115

References command, 116

Require Variable Declaration option, 129

starting a new procedure, 137–138

Tools menu, 116

UserForm toolbar, 118

View menu, 116

Watch window, 198–199

Window Settings option, 132–133

VBA objects, 70

VBE. See VBA Editor

VBScript, 381–384

views, 345–346

Visual Basic, 64

adding the ADO Data Control, 374–381

components, 373–374

support for data access, 374–381

Visual Basic Editor. See VBA Editor

Visual Basic for Applications. See VBA