Hhq

backing up in code, 45

bar charts, 195

barriers to VBA programming lack of Visual Basic knowledge, 12 learning curve, 12 macro recorder flaws, 11-12, 28 BaseSize property (charts), 198

BASIC, 12, 29-30 BeforeClose() event, 145

BeforeDoubleClick() event,

149, 154, 158, 418-419 BeforePrint() event, 144

BeforeRightClick() event,

150, 154, 418-419 BeforeSave() event, 144, 160 binding. See data binding blank cells, deleting from pivot tables, 245-246

blank report worksheets, moving pivot table data to, 251

bookmarks, 371-373

BookOpen() function, 77-78 bounding rectangles, 186 breakpoints, 44-45, 50 Bring to Front command (UserForm toolbar), 433

BrowseForFolderShell()

function, 294 bubble charts, 196 BubbleSort() function, 96 buttons adding to toolbars, 488-489 assigning macros to, 16-17 command buttons, 492-494 help buttons, 427-429 option buttons, 167-168 SpinButtons, 169-170 toggle buttons, 436 X button, 458-459

0 0

Post a comment