D

Dash (-), avoiding in XML element names, 336 Data, saving as XML spreadsheet, 342-343

Database files, 296

DataBinding property, Xml Map object and, 346 Data columns, in Combo Box and List Box controls, 228 Data markers, image mapping and, 400, 401 DataPoints variable, 403, 411 Data types, 26, 31-40, 47, 54 Boolean, 39 common VBA, 32 numerical, 31-34 specifying, 28 string, 37-38 variant, 38-39 Data Validation dialog box, 109 Date type, 47

DateDiff() function, 52, 141 DateValue() function, 107

Date variables, in Biorhythms and Time of Your Life program, 52 Day() function, 53

DealCards() sub procedure, playing a hand of Blackjack and, 254, 256

DealerDraw() sub procedure, playing a hand of Blackjack and, 262 Debugging, 270, 274-279 Break Mode, 274-275 Immediate window, 275-277 Locals window, 279 Watch window, 277-279 Debug object, Assert() and Print() methods of, 276 Debug toolbar, 275 DEC constant, 322

Declare statement, Windows API and, 204 Declaring arrays, 111-112, 115 dynamic arrays, 116-117, 118 variables, 27-31 Delay() sub procedure, 247 DeleteBonus() sub procedure, 469 Denormalized maps, 355 Derived class, 151

Derived data types, in VBA, 233-237 Description property, of Err object, 273 Design Mode, 11, 12, 15 Design time, 9, 213 Destination argument, 122, 348 Dialog boxes custom designing using forms, 215-233 for quick statistics, 226-233 Dialogs object, 282

Dice rolling, in Poker Dice program, 84-87 selecting, in Poker Dice program, 81-82 Digital certificates, 4 Digital signatures, 4 Dim keyword, 31, 211 Dim statement, 27, 28 Dir() function, 303 DisplayFormulaBar property, 160 DisplayResult() sub procedure, 86, 88 Divide by zero error, 270 Division operator (/), 33 .doc files, 280 DoEvents() function, 247 Do keyword, 101

Dollar signs ($), in front of indexes, 120 Do loops, 101-103, 107 Dot (.) operator custom data types and, 235 random access files and, 295 Double data type, 31, 32 Doubling down, in Blackjack game, 267 Drawing layers, in worksheets, 428 Drawing toolbar, 427, 429 DropButtonClick() event procedure, 230 of Combo Box control, 226 of RefEdit control, 222 DropShapes() sub procedure, 447, 453 Dynamic arrays, 116-120

in Math Game program, 134 DynamicBubble() procedure, 118 Dynamic link library (.dll) files, 203 DynamicTranspose() sub procedure, rewriting with dynamic array, 119

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment