xlsm file, EmpData database
worksheet, 150
HumanResources.uspUpdateEmployee
PersonalInfo, 82
nI
ID property, adding to business object
classes, 161
ID Property Let function, adding call to,
162??“163
Image control, in Toolbox window, 39
Immediate window, 10??“11
checking value of variables in, 268
testing cEmployee class in, 33
InfoPath Form Template project, added in
VSTO SE, 325
InitForm subroutine, creating, 180??“182
initialization and cleanup code, adding to
cCustSurvey class module, 141
InitLists subroutine, adding, 180??“182
InitWizard subroutine, adding to UserForm
code, 179??“180
Insert ribbon, selecting chart type from, 207
InsertChart procedure, adding to Standard
Module 1, 296
InsertText procedure, adding to Standard
Module 1, 296
IntelliSense, 100
iWhere variable, 236
nJ
Jet engine, 54??“59
nINDEX 355
nKL
Label control, in Toolbox window, 37
Len function, using for UserForm1, 146
Library drop-down list box, in Object
Browser, 25
ListBox control, in Toolbox window, 38
ListMgr worksheet, contents of, 151
ListObjects.Add method, changing Source
property of, 47
lists, managing, 169
Locals window, 11??“12
at work, 269??“271
Type mismatch error 13 in, 269
loops, testing within Immediate window, 268
nM
macro
recording, 14??“20
writing in VBE, 20??“24
Macro Recorder,
and Code Modules, 1??“41
CreatePivotTable method called by, 230
macro security
creating more, 21??“24
settings for, 1-4
macro-enabled file types, 22
macros, adding ribbon to run custom,
128??“129
maillist.
Pages:
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324