1297
Index
debugging technique, 534–535
macro error handling, getting, 1073
error numbers, macro error handling, 1073
error reporting, ribbons, 1024
error trapping on Visual Basic procedures, 1099
ErrorRoutine function, 778–780
Euro format, 61
even-odd page printing, 733–735
[Event Procedure] option
attaching event procedures, 397–398
creating event procedures, 439–441
event procedures as default development language, 391
event procedures. See VBA, event procedures.
event properties, 387. See also VBA event procedures; VBA
procedures.
Event properties, 283
events. See also table events; VBA events; specific events.
assigning macros to, 1052–1054
class, 997–999
in class modules, 1005–1008
forms, 699–700
need for, 1000–1001
overview, 1000
passing data through, 1004–1005
raising, 1002–1003
events, custom
creating, 1001–1002
trapping, 1003–1004
Excel data, linking to, 587, 591–594, 602–603
exceptions. See error handling.
exclamation point (!)
displaying input masks, 67
in With keyword, 895
left-aligning a display, 60
left-aligning text, 60
Not operator, 195–198
Exit Do statements, 405
Exit event, 460
ExitForEachRecord action, 560
expanding submacros, 1059
explicit variables. See also implicit variables; VBA, variables.
effects on performance, 430
forcing, 394, 411, 431
forcing declaration, 411
versus implicit, 430
importance of, 424
syntax, 424
export errors, SharePoint deployment, 1151stopping for errors, 411
unanticipated errors, 823–824
untrapped errors, 823
error handling, data macros
ClearMacroError action, 562
error response, 561
logging errors, 560–561
OnError action, 561
RaiseError action, 562
raising errors, 562
resetting errors, 562
error handling, macros
ActionName property, 1073
arguments, getting, 1073
Arguments property, 1073
condition, getting, 1073
Condition property, 1073
Description property, 1073
error message, getting, 1073
error number, getting, 1073
macro action, getting, 1073
MacroError object, 1073–1074
MacroName property, 1073
mcrDivisionErrorHandling macro, 1071–1073
name of failed macro, 1073
Number property, 1073
OnError action, 1071–1073
overview, 1069–1070
error handling, trapping errors with On Error statements,
825–826
error handling, trapping errors with VBA
disabling error handling, 831
Err object, 827–829
Error events, 836–837
On Error GoTo 0 statements, 831
On Error GoTo Label statements, 830–831
On Error Resume Next statements, 831–832
error-handling statements, 829–835
ignoring errors, 831–832
overview, 826–827
Resume Label statements, 834–835
Resume Next statements, 834
Resume statements, 832–834
resuming after errors, 832–835
error messages. See also messages; MsgBox function; specific
messages.
built-in, 822–823
data validation, 6952_475348-bindex.indd 129752_475348-bindex.indd 1297 4/1/10 2:02 PM4/1/10 2:02 PM