| < Day Day Up > |
|
DAO (Data Access Objects), 481
data
in a collection class, 316
copying, 185-87, 422-24, 427-28
displaying graphically, 321
managing large volumes, 347
manipulating, 193-217
from multiple perspectives, 341
validating, 429-30
data area
in PivotChart, 346
in PivotTable, 358
Data Consumer, 481
data entry, 187-89
data fields
adding to PivotTables, 350
defining for PivotTables, 358
data files
creating XML, 549-50
importing into an XML schema, 552
data form, 540
data labels. See labels
data lists, 539-41
creating, 540
creating programmatically, 541-46
data map, 550, 551
Data Provider/Data Consumer model, 481
data providers for Access, 485
data series, modifying a chart's, 331
Data Series object, 322
Data Source keyword, 485
data sources
for Excel VBA, 481
for a ListObject object, 542
using the Internet as, 527-32
data types
associated with parameters, 490
available for validation, 188
conversion functions for, 61
creating custom, 72
defining, 58-59
for elements, 548
in relational databases, 468
returned by a Function procedure, 99
data validation code, 82
database client, 470
database info, saving, 504
database keys, 469. See also keys
database management systems, connecting to, 485-86
Database Properties dialog box, 501
Database Properties window, 516
database providers, changing, 503
database queries. See queries
database server, 470
database tables. See tables
databases
accessing from Excel, 470
comparing to spreadsheets, 467-70
connecting to, 501-5
designing and administering, 469
fundamental concepts, 467-69
manipulating with SQL, 471
retrieving rows from, 513
using with Excel, 467
databases administrator, 469
DataBodyRange property, 541
DataFields property, 350, 354
Data_Form reserved name, 182
DataRange property
of PivotField object, 354
of PivotItem object, 356
DataType parameter, 133
DataType property, 354
date and time functions, 213-16
Date arguments of DateDiff function, 216
Date data type, 60
Date format, default, 214
Date function, 214
date serial numbers, 213
Date variables, 60
DateAdd function, 214, 215
DateDiff function, 215
dates
difference between two, 215
handling, 60
manipulating, 213-17
prior to January 1, 1900, 213
DateSerial function, 214, 215
Date/Time data type, 61
DateValue function, 214
Day function, 214
days, number between events, 213
DB2 databases, 486
DBInfo user form, 498
initializing, 502-3
opening, 500
DblClick event, 402, 404
DBPath value, 510-11
DBQuery user form, 498
loading, 505
opening, 500
DBType variable, 510
DBWindowsAuth value, 511
Deactivate event
with user form, 400
for workbook, 269, 271
Debug menu, 46-47
debugging, 34
converting to, 61
the execution of procedures, 46
with hidden application objects, 458
macros, 34-36
Decimal data type, 58
DecimalSeparator parameter, 134
DecimalSeparator property, 529
decisions, made by applications, 74-77
declarations, avoiding errors through, 50
declarations section
declaring module variables in, 63
displaying for a code module, 92
entering using the keyboard, 93
default buttons in a message box, 69
default Date format, 214
default docked location, 49
Default to Full Module View, 51
Default Web Site Properties dialog box, 533
Define Name dialog, 182
Define Names dialog box, 17
Definition item on the View menu, 44
Delay property of SpinButton control, 407
Delete key, 127
Delete method
of a button, 261
of Charts collection, 152
of CommandBar object, 367
of CommandBarControl object, 374, 375
deleting a command bar, 371
invoking, 152
of ListObject object, 542
of Parameters collection, 489
of Recordset object, 491, 494
removing the entire command bar, 501
of Series object, 340
of Sheets collection, 152-53
of Validation object, 189
of Worksheets collection, 152
of XmlMap object, 554
Delete statement, 471, 479
DeleteCommandBar routine, 500
DeleteMenu procedure, 273
Delimiter parameter, 131
delimiters
for cells, 132
defining non-standard, 134
other than commas, 132
treating consecutive, 133
Desc (descending) keyword, 476
Description property
of Err object, 83
of Error object, 487
Description subkey for COM add-in, 250
descriptive names, 55
Deselect method, 330
Design mode, toggling, 48
Design Mode item on Run menu, 48
DetermineAllInterest procedure, 210
DetermineInterest procedure, 209
dialog boxes
customizing, 383-94
displaying existing, 384-88
documentation for, 386
formatting cells, 391
inserting or modifying charts, 391
modifying default settings in, 393
modifying existing, 388-94
passing arguments to existing, 393
setting default choices within, 388
Dialog object, 384
dialog sheets, 13
dialog types, 293
Dialogs collection, 384, 385, 389-93
Dialogs property, 393
dictionaries, 20
dictionary words, avoiding for passwords, 144
digital certificates, 38, 39
digital signatures, 37, 39
Digital Signatures dialog box, 48
digits, number visible in a cell, 175
Dim New statement, 301
Dim (dimension) statement
declaring objects, 302
declaring strings, 60
declaring variables, 58
Dir function, 282
Direction property of Parameter object, 490
directory organization for a computer, 287
dirty user forms, 427
Disable Macros, 37
DisableCustomize property, 366
DisableSave routine
in GetData routine, 424
in PutData routine, 428
DisableSave subroutine, 427
DiscountedPrice function, 255
DiscountPrice function, 250
DisplayAlerts property, 116, 152
DisplayDrawingObjects method, 139
DisplayErrorString property, 350
DisplayNullString property, 350
DisplayOutlookContactNamesEarly Binding procedure, 453
DisplayPalette procedure, 223, 225
DisplayRightToLeft property, 541
#DIV/0! error value, 124
divide by zero error, 50
DLL components, 248
DLL file, creating, 254
Do Until...Loop, 79-80
Do While...Loop, 79-80
dockable windows, specifying, 52
docked location for windows, 49
Document object, 457
Document Recovery task pane, 20
Document Updates task pane, 20
document workspaces, 6
documents, Word, 457-62
Do...Loop Until loop, 80-81
Do...Loop While loop, 80-81
DOS window, starting Windows- based applications from, 446
dot notation
calling methods, 27
placing the name of a module, 94
referring to properties in VBA, 26
with Select statement, 477
dots in a pixel, 220
Double data type, 59, 61
double quotation marks, 60, 473
Down Arrow key, 127
Drag-and-Drop-Text option, 51
DragToColumn property, 355
DragToData property, 355
DragToHide property, 355
DragToPage property, 355
DragToRow property, 355
drawing objects, 139
DrawingObjects parameter, 157
DropButtonStyle property, 414
drop-down button, hiding, 414
drop-down lists, 379
DropDownLines property, 378
DSTDEV function, 4
DSTDEVP function, 4
duplicate colors in color palettes, 225
DVAR function, 4
DVARP function, 4
dynamic arrays, 66
| < Day Day Up > |
|