72.

D

databases

appending worksheets to, 40-46

closing, 45-46

connection to PivotTables, 263

defining range, 41

editing connection string, 263

importing data, 259-61

opening dBase files in Excel, 41

redefining, 41-42

DataBodyRange property, 135

data connection files, relationship to PivotTables, 264

Data Connection Wizard, 259-61

data fields

adding second one, 133

assigning to variables, 133

creating, 134

naming, 134-35

vs. other fields, 133

overview, 133

removing, 134

DataFields collection, 130

DataLabelRange property, 136

Data Link Properties dialog box, 260

data types, converting, 166

Data worksheet

creating formulas from range addresses, 114-16

Return to Menu command and, 286

Date function, 234

dates

adding to records via AddDates macro, 38-40

checking validity of data entry, 145-46

finding, 243-44

initializing in Print Options text box, 234

prompting for entry via TestInput macro, 144-46

testing formats, 146

dBase. See databases

DblClick event, 198

Debug menu, 158

Delete method, 64

DeleteSheet macro, 174-75

Design Mode button, 214

dialog boxes. See user forms

digital signatures

adding to VBA projects, 21

authentic, 22

creating, 19-21

trusting, 22

ways to obtain, 19

directories, listing files via ListFiles macro, 153-55

Dir function, 153

DisplayAlerts property, 47

DisplayGridlines property, 14

dockable views, 57-62

dollar sign ($), absolute references

Do loop

in ListFiles macro, 153-55

in MakeNextReport macro, 177-78

overview, 155

drawing objects

Excel vs. Office, 87

overview, 69

vs. shapes, 87

DrawingObjects class, 76-77

Drawing toolbar, 276

drop-down list boxes, 217-20



Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net