Index_B

B

B29 input cell , 674

BA object library, 131

Background Query option, 709

backups , automatic, 49

balance sheet example, 518-25, 602-18

components of application, 607-8

editing preexisting invoice, 616-18

essential fields, 519-20

event procedures, 613-14

initializing Invoice form, 612-13

macros for, 43

opening Excel file for monthly reports , 610-11

overview, 518-19, 602

printing form, 524-25, 614-15

program code, 608

rate calculations, 521-23

removing keyboard focus from listboxes, 613

running program, 603-6

saving Data from Invoice form in monthly report, 615-16

table construction, 520-21

Workbook Open procedure, 609-10

BarTypeMenuBar property, 467

BarTypeNormal property, 467

BarTypePopup property, 467

BeforeClose event, 145, 157

BeforeDoubleClick event, 146, 157, 158

BeforePrint event, 145, 157

BeforeRightClick event, 146, 157, 158

BeforeRightClick event procedure, 477

BeforeSave event, 145, 157

BeginGroup property, 469, 484

billing form for mail-order business example, 41-42

binary files, 278-83

add-ins compiled to, 736

character strings in, 282-83

data channels, 278-79

user -defined data types and fields in, 283

Binder object, 59, 808

binding between objects and methods , 782

bitmaps, 854

(Blanks) setting, 583

BOF (bottom of file) Recordset property, 659, 667

Bold property, 61

Book class, 170-71

Bookmark property, 660, 667

Boolean variables , 61, 88, 95, 282

Border objects, 208-10, 808

BorderAround method, 195

Borders method, 195

Borders object, 808

borders of cells , 208-10

Borders property, 58

bottom of file (BOF) Recordset property, 659, 667

BottomRightCell property, 561

branching, 112-15

with IfThen, 121

with Select Case, 121

Break in Class Module option, 74

Break in Unhandled Errors option, 74

Break on All Errors option, 74

breakpoints, 377

Brosius, Gerhard, 707

browsers, and Web components, 742

btnAgain_Click procedure, 38

btnCreatePivot1_Click() method, 711-12, 713

btnEdit_Click procedure, 38, 39

btnEnd_Click procedure, 38

btnInput_Click macro, 23

btnNext_Click procedure, 37, 38

btnOK_Click method, 557

btnOK_Click procedure, 38

btnPrint macro, 521

btnPrint_Click procedure, 524-25, 614

btnPrintAndSave_Click procedure, 513

error response, 515

PrintOut method in, 514

program code, 514-17

worksheet protections , 515

btnShowAll_Click macro, 23

btnStar_Click procedure, 563-64

btnStartTrainer button, 39

BuildPath method, 275

BuiltIn property, 483, 484

BuiltinDocumentProperties property, 59

Buttoni_Click macro, 135

buttons . See also names of specific buttons

adding to literature database, 19-23

command, 421-22

embedded in worksheets, 61

image editing, 461-62

option, 419-20

special features of, 444

spin, 429-30, 453-56

toggle, 421-22

ByRef, 163

Byte variables, 88, 282

ByVal keyword, 100, 757

ByVal parameters, 109