G

games, 98

GetObject function, 651-652 GetOption function, 861-864 GIF, saving chart as, 500, 895 global issues country code, displaying, 806-808 CSV files, 73

date and time settings, 813-814 local properties, 810 other languages, 802, 808-809 system settings, 810-813

VBA language, 809 globally unique identifier. See GUID goal, sample, 263 GoTo statement error-handling, 260-262 executing, 220-221 graphics button, adjusting on command bar, 722-724 control picture property, changing in chart,

416, 500 toolbar, 725, 735, 918 Toolbox controls, 410 worksheet button, 572 graphing tips, 585-587 graphs animated, 587-588

arbitrary data labels, displaying, 570-571 chart sheet described, 547 workbooks, 17-18 XLS and XLA, 679-680 ChartObjects, sizing and aligning, 559 "clock," 589-591 creating "dead," 583-585 data series control with Autofiltering,

592-593 data, specifying, 563-566 deleting from ChartObjects or Charts collection, 556-557 determining whether activated,

555-556, 904 displaying in UserForm creating on-the-fly, 572-574 described, 498-499 OWC ChartSpace control, 500-503 saving as a file, 498-500, 910 embedded printing on full page, 583 selecting, 28 events described, 574-582, 606 finding with Object Browser, 628-629 listed, 627-628 Excel, 30-31

graphs continued formatting, 557-558

GIF, saving as, 500, 895

hypocycloid, 588-589

interactive, 601-604

locations, 547-548

looping through all, 558-559

macros, recording, 550-553

names, using in a SERIES formula, 561-563

object model, 548-550 sizing and aligning, 559 spot in hierarchy, 163 OWC ChartSpace control, 500-502 pivot, 560 properties, 177

ranges, determining, 566-569 saving as a file, 499-500 self-expanding, creating, 594-600 storing multiple on sheet, 593-594 text, displaying with "MouseOver" event,

585-587 VBA, activating with, 553-555 GridLines formatting, 414 menu display, 755-756 grouping class of objects add-in, 683-685

comment object case study, 171-172 defined, 132, 900 ListBox items, adding, 458 manipulating, 216-220 membership, testing for, 354 operation, performing on all objects in (For Each-Next construct), 218-220 VBA programming, 164 Toolbox controls (Frame), 410 GUID (globally unique identifier), 846

0 0

Post a comment