xlsm project, importing
cExcelUtils class to, 138??“139
UserForm1
coding, 143??“150
settings and controls, 136??“137
UserForms, 36??“39, 133??“191
adding to projects, 134??“135
coding, 143??“150
creating wizard-style data entry, 150??“191
example with controls added, 39
Excel naming of, 36
inserting into projects, 36
UserForm_Initialize event, 144
adding code to, 178??“179
UserForm_Terminate event, 144
adding code to, 188
uspGetManagerEmployees stored procedure,
parameters taken by, 68
nV
validation code, adding to cCustSurvey class
module, 141??“142
Value Field Settings dialog box, changing
field names in, 243
Value2 property, current cell??™s value stored in,
269
variable values, viewing, 267??“275
variables, checking in break mode, 267??“275
VB code, benefits of vs. VBA code, 316
VBA (Visual Basic Application), calling
parameterized SQL in, 71??“73
VBA code, benefits of vs. VB code, 316
VBA code window Object box, choosing Class
from, 32
VBE code window. See code window
View Definition button, in Object Browser, 26
Visual Basic development environment, 4??“14
Visual Basic Editor (VBE), 5, 14
adding FileExists function in, 277
opening, 254, 288
Options dialog box showing color options,
264
panes in, 5
updating PivotTable in, 236??“238
when breakpoint is reached, 264
writing a macro in, 20??“24
Visual Studio 2005 start page, recent projects
section of, 327
Visual Studio Tools for Office Second Edition
(VSTO SE). See VSTO SE
VSTO and VSTO SE
project templates, 323
tools for creating Excel projects, 323??“327
VSTO SE
Excel 2003 and Excel 2007 Add-ins, 325
new project types included in, 324
web site address for free download, 327
nW
Watch window
elements, 13??“14
handling watched values in, 272??“275
watch types, 272??“273
web site address
example files and source code, 20
for free VSTO SE download, 327
for running examples on Vista, 43
Wikipedia Object_database, 172
Windows Vista
registering Nwind2Excel.
Pages:
311
312
313
314
315
316
317
318
319
320
321
322
323
324