Index_B

---

B

BackColor property

of text box, 439

of user form control, 402

of UserForm object, 398, 399

background

setting, 430

for UserForm object, 399

Background Compile option, 52

Background property of Font object, 232

Backspace key, 126

BackupXML procedure, 556

.bas (Basic) file, importing, 45

base object. See root object

base tables, 468

Basic file (.bas) file, 45

Before parameter

of Add method, 150

of Move and Copy methods, 153

BeforeClose event for a workbook, 269

BeforeClose event procedure, 272-73

BeforePrint event, 269, 271

BeforeRefresh event, 529

BeforeRightClick event, 274, 276

BeforeSave event, 269, 271

BeginGroup property, 373

binding, 449

BINOMDIST function, 4

bite-sized procedures, 104

black boxes, chart handles displayed as, 324

black VBA color constant, 219

BlackAndWhite property of PageSetup object, 154

blank cells

allowing, 188

checking for, 296

counting, 206

blue VBA color constant, 219

BlueBorder procedure, 236

BOF property of Recordset object, 491, 492

Bold property of Font object, 232

BorderAround method, 237

borders, formatting, 236-37

Borders object, 236

Borders property, 236-37

BottomMargin property, 154

BottomRightCell property, 337

boundaries of arrays, 64

brackets <> around markers, 203

Break in Class Module option, 52

Break item on the Run menu, 48

Break key, 126

Break mode, placing code in, 48

Break on All Errors option, 52

Break on Unhandled Errors option, 52

breakpoints, 35

clearing, 35, 47

creating in code, 47

inserting in macro code, 35

Browse button in Add-in Manager, 241

browsers

displaying interactive components, 526

interpreting names of colors, 226

interpreting RGB color values, 226

BuildConnectionString function, 508

BuildConnectionString routine, 509-11

built-in command bars, 9

built-in constants

not available with late binding, 454

in VBA, 59

Built-in Dialog Box Argument Lists help topic, 384

built-in dialog boxes

arguments accepted by, 388

vs. constant, 400

documentation for, 386

BuiltIn property

of CommandBar object, 367, 368

of CommandBarControl object, 373

BuiltInFace property, 376

business rules, 317-18

button controls, 375

button objects

arranging on a user form, 46

defining, 259

button options for message boxes, 68-69

buttons

adding to toolbars, 260

combining into a single command bar, 377

removing from toolbars, 261

specifying in a message box, 68

visual state of, 376

ways of displaying, 376

Byte data type, 58, 61

ByVal keyword, 103

---