Excel VBA Macro Programming
D
Data services layer (Excel object model), 126
Data types
of arguments, 31
of pasted data from other applications, 205
user -defined, 22 ‚ 23
of variables , 12, 16 ‚ 18
VBA, 18 ‚ 19
Database table, getting data from, 180 ‚ 181
Databases, working with, 177 ‚ 181
Date function, 55
Date and time format characters (Format function), 53
Date and time formats (Format function), 52
Date and time functions, 54 ‚ 60
Date and time values stored in variants, 17
Date and time of workbook creation, 221
DateAdd function, 55 ‚ 56
DateAdd function Interval parameter, 55
DateDiff function, 56
DateDiff function Interval parameter, 56
DatePart function, 57
DatePart function Interval parameter, 57
DateSerial function, 57 ‚ 58
DateValue function, 58
Day function, 58
Debug mode (instant watch mode), 78 ‚ 80
Debug window, 82 ‚ 83
Debugging, 77 ‚ 86
events that cause problems when, 84
procedure stepping, 81
running parts of code, 80 ‚ 82
single stepping, 81
stepping through code, 80 ‚ 81
using commenting in, 86
using message boxes in, 84 ‚ 85
Decisions, coding, 33, 34 ‚ 37
Default dialogs, 114 ‚ 115
Delete command, 298
Delete method, 118, 126, 154, 283
Design time mode (VBA), 78
Design-time errors, 78
Dialogs, 91 ‚ 105
Common Dialog control, 107 ‚ 115
default, 114 ‚ 115
Dialogs collection (Application object), 144
Dim (Dimension) statement, 12 ‚ 14, 20 ‚ 22, 133, 136 ‚ 137
Dim statement As type clause, 12
Disk space available, API call to get, 184 ‚ 185
Display properties (Windows object), 150 ‚ 151
Division (/) operator, floating-point, 69
Division (\) operator, integer, 69
DLL (Dynamic Link Library) files, 183 ‚ 184
Do Until loops , 39 ‚ 41, 187 ‚ 188
Do Until loops including Exit Do, 41
DoEvents command, 187 ‚ 188, 201
Dot notation for properties, 23, 129
Drawing toolbar (Autoshapes menu), 291
DSN (data source name ), setting up, 177 ‚ 179
Dynamic arrays, 21 ‚ 22