Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

3-D effects in charts , 591-592

Daily Dose of Excel Web site, 976

DAO (Data Access Objects), developers and, 13

data analysis, developers and, 13

data entry

introduction, 30

next empty cell , 323-324

overview, 102

validation, 648-651

data forms, displaying, 410-411

data labels, charts, displaying, 598-600

data storage, 106

Data tab (Ribbon), 728

data types

Boolean, 978

built-in, 195

Byte, 978

cells , determining, 335-336

Currency, 978

custom, defining, 981

Date, 978

Decimal, 978

Double, 978

Integer, 978

Long, 978

Object, 978

Single, 978

strictly typed, 194

String, 978

user -defined, 212-213

variables and, 193

Variant, 978

data validation, UserForms, 436

DataAndTime procedure, 349-350

database files

accdb, 79

accde, 79

dbf, 79

mdb, 79

mde, 79

Database functions, category, 308

databases

Excel as manager, 102

external, 40

DataLabelsFromRange procedure, 599

DataPivotField object, Orientation property, 563

data-typing variables, 201

date

convert string to, 983

convert to serial number, 983

day of the month, 983

month as number, 985

month as string, 985

part, 983

returning, 983

setting, 977

time interval, 983

year, 987

Date & Time functions, category, 308

date accessed extended property, 839

date and time

Date data type, 206

displaying, 349-350

entering, 67-68

file last modified, 830

format, 983

international applications, 828

pre-1900, 68-69

returning, 985

Date and Time dialog box, 676

date and time last modified, 983

date bug, 206

date created extended property, 839

Date data type, 195, 206, 978, 982

Date function, 349-350, 983

date modified extended property, 839

date picture taken extended property, 839

Date statement, 977

DateAdd function, 983

DateAndTime function, 349-350

DateDiff function, 983

DatePart function, 983

DateSerial function, 983

DateValue function, 983

David McRitchie's Excel Pages Web site, 976

Day function, 983

day of week, 987

DblClick event, 661

DDB function, 983

DDE/External functions, category, 308

Deactivate event, 603, 641-642, 654

deactivating , charts, 580

debugging, functions, 305-306

decimal

converting to hexadecimal, 984

converting to octal, 985

Decimal data type, 195, 978, 982

DECIMAL2RGB function, 904

declarations

arrays, declaring, 211

arrays, multidimensional, 210-211

constants, 204, 977

description, 145

functions, 281-283

Sub procedures, 238-239

variables, 197-199, 978

Declare statement, 978

Default to Full Module View option (VBE), 155

DefBool statement, 978

DefByte statement, 978

DefCur statement, 978

DefDate statement, 978

DefDbl statement, 978

DefDec statement, 978

DefInt statement, 978

DefLng statement, 978

DefObj statement, 978

DefSng statement, 978

DefStr statement, 978

DefVar statement, 978

DeleteEmptyRows function, 332

DeleteFromShortcut procedure, 772

DeleteSetting statement, 978

DeleteToolbar procedure, 759

deleting

from ChartObjects collection, 581-582

from Charts collection, 581-582

files from disk, 830, 979

rows, empty, 332

depreciation, straight-line, 986

descriptive information for add-ins, 705-706

Deselect method, 580

Developer tab (Ribbon)

description, 728

showing, 930

turning on, 139

developers

add-ins, compiled, 13

ADO and, 13

automation and, 13

controls and, 13

DAO and, 13

data analysis and, 13

description, 99-100

dialog boxes and, 13

file structure and, 13

insiders, 99

Microsoft Query and, 13

outsiders, 99

security and, 13

shortcut menus and, 13

user interface and, 13

VBA and, 13

Web pages and, 14

worksheet functions and, 13

Device Input/Output (I/O) error, 990

Device unavailable error, 990

DHTML (Dynamic HTML), 795

dialog boxes. See also custom dialog boxes

Add-Ins, 702-703

Apply Names, 54

built-in, 407-410

Control Panel, running, 675-676

custom, 27, 117-118

Date and Time, 676

developers and, 13

input boxes, 390

Insert Function, 306-310

Macro, 241

modal, 27

modeless, 27

Move Chart, 578-579

Name Manager, 53

New Name, 53

testing, 434-435

UserForm and, 27

dialog sheets, 16, 20

Dialogs collection, 407-408

Dim statement, 213, 978

dimensions extended property, 839

Dir command, 830

Dir function, 832-833, 983

directories

change, 830, 977

creating, 830, 979

empty, removing, 830, 980

listing files, 831-833

pattern matching name, 983

prompting for, 403-407

renaming, 830, 980

selecting, Windows API and, 404-406

DisableAllShortcutMenus procedure, 769

DisableHideMenuItems procedure, 770

disabling

Close button, UserForms, 456

events, 632-634

shortcut menu items, 770

shortcut menus, 769

disappearing macros, 931

disk drive, Windows API, 378

Disk full error, 990

Disk not ready error, 990

display

charts in UserForms, 524-526, 600-602

customizing, 30

data forms, 410-411

slide shows, 611

text, MouseOver event and, 615-617

UserForms, 427-428

distribution, add-ins, 708

distribution of application, 127

#DIV/0! error, 60

Division by zero error, 989

DLL (Dynamic Link Library) files referencing external procedures, 978

Windows API, 311

Do Until loops , 235-236

Do While loops, 232-234

Docking tab (VBE), 157

document themes

colors, 911-914

colors, displaying all, 915-917

introduction, 18

overview, 910-911

documentation, 125-126

documents, hiding, 123

DoEvents function, 983

Do-Loop statement, 978

dot operators, objects, 167

Double data type, 195, 978, 982

Drag-and-Drop Text Editing option (VBE), 155

DragOver event, 603

DragPlot event, 603

drawing layer, ActiveX controls, 118

drives , change, 830, 977

drop- downs , Ribbon, 22-23

DupeRows function, 333

duplicating, rows, 333-334

duration extended property, 839

dynamic arrays, declaring, 211

dynamicMenu control, Ribbon, 752-754

dynamicMenuContent procedure, 754