1339
Index
Command-Line Arguments option, 414–415
Compile on Demand option, 411
compiler directives, 413–414
Conditional Compilation Arguments option,
413–414
#Const compiler directive, 413–414
Editor tab, Options dialog box, 410–412
explicit variable declaration, forcing, 394, 411, 431
#If compiler directive, 413–414
indenting code, 411
object hierarchies, listing members of, 411
Options dialog box, 410–412
Project Description option, 413
Project Name option, 413
Project Properties dialog box, 412–414
Require Variable Declaration option, 411
stopping for errors, 411
syntax checking, 411
variable values, displaying, 412
VBA editor. See also editing.
& (ampersand), continuation character, 419
_ (underscore), continuation character, 418–419
comments, color coding, 419–420
identifiers, color coding, 419–420
indenting lines of code, 418
keywords, color coding, 419–420
object list, sorting, 420
splitting statements, 419
statement continuation, 418–419
VBA [Event Procedure] option
attaching event procedures, 397–398
creating event procedures, 439–441
event procedures as default development language, 391
VBA event procedures. See also VBA procedures.
attaching, 397–399
for controls, 459–460, 462–463, 466–468
as default development language, 391
definition, 387
identifying, 391
modifying, 391
for reports, 460–462
spaces, in event names, 455
VBA event procedures, creating
by copy and paste, 455
on forms, 456–459
methods for, 397–399
overview, 453–454
steps in, 439–441extending, 387
keywords, 379
versus macros, 382, 1077–1078
name origins, 379
named arguments, 447–448
naming conventions, 432
overview, 378–379
submacros, 1068–1069
subprocedures, 388
variables, 380
VBA branching
Case Else clause, 404
definition, 401
Else statements, 402
ElseIf clause, 402–403
If...Then...Else...Endif statements, 401–403
If...Then...Endif statements, 401–403
overview, 401
Select Case...End Select statements, 403–404
VBA callbacks
overview, 1023–1025
writing, 1027–1029
VBA code
bulletproofing, 933–934
compiling, 532–534
grouping variables by data type, 531–532
organizing, 530–532
VBA collection items
counting, 407
naming conventions, 407
number of, effects on performance, 408
referencing, 407
VBA collections
Count property, 407
counting items in, 407
definition, 406
Item property, 407
looping through, 408–410
Name property, 407
naming conventions, 407
properties of, 407
VBA developer options
Auto Data Tips option, 412
Auto Indent option, 411
Auto List Members option, 411
Auto Quick Info option, 411–412
Auto Syntax Check option, 411
Break on all Errors option, 411
command-line arguments, 414–41552_475348-bindex.indd 133952_475348-bindex.indd 1339 4/1/10 2:02 PM4/1/10 2:02 PM