Vba Excel Numlock

charts, using in a SERIES formula, 561-563

described, 25-27

Excel's means of handling, 598

formula cells and ranges, setting (Ctrl+F3), 48-49 columns and rows, 51 constants, 51-53

entering directly into Define Name dialog box, 53-54

to existing references, 49-50 hidden, 50 intersecting, 50-51 "natural language," 52 objects, 54-55 scoping, 51

understanding cell and range names, 54 fullname property of add-in object, 685 functions declaring, 283 finding, 26 Macro Recorder, 160 month, returning array, 295-298 in object hierarchy, 163 prompting to add to next empty cell,

323-324 property of add-in object, 685 range, 902

toolbar, changing, 702 trimming parts of with megaformulas, 64-66 variables, 203 VBA procedure, 238, 239 worksheet, 266 #NAME? error, 55 named cells, 54 named formulas creating, 596 self-expanding chart, 599 named ranges, 54, 319 naming object class, 872 "natural language" formula name, 52 negative number, counting cells, 60 nesting

For-Next loops, 232 If-Then constructs, 224 newsgroups, 924-928 NewSheet event, 616 Next button wizard, 482 next comment, returning, 171 non-relative cell and range references, benefits of using, 45-46 nonzero values, counting cells, 60 Not operator, 208, 343-344 Novell, 7

nth element, extracting from string, 364-366 #NULL! error, 55

Num Lock key, status of, 866-871 number code type returned by Excel InputBox method, 388 formatting, 28 getting, VBA text files, 826 invoice, generating unique, 905 text files, 825

VBA error code listed by, 943-946 number sign (#), 201, 831

object arguments, passing to procedures, 254-258 colors, setting, 174 comment object case study, 173-175 concepts, essential to VBA programming,

184-185 data type, 196 data type prefix (obj), 203 defined, 132 events add-in, 688 events not associated with, 606 Excel's use of, 15-16 formula names, 54-55 GetObject function, 651-652 hierarchy, 133, 163-164 listing, 707-708, 899 locking on worksheet, 120 methods, listing, 899

multiple operations, performing (With-End

With instruction), 217 parents, 358-359 properties hierarchy, 133 listing, 899

VBA programming, 165-166 selecting, 27-28

Sub procedures, clicking, 252-253 VBA class modules, 871 VBA programming described, 163-164 manipulating, 216-220 methods, 166-168 properties, 165-166

referring to, 164-165 variables, 211-212 Object Browser dialog box constants, listing, 404 finding chart events with, 628-629 properties and methods, listing, 186-187, 899 object class, creating new. See class module, VBA

Object Linking and Embedding. See OLE object model charts, 548-550 described, 16 VBA, 130 Office Assistant, 777-780 Office (Microsoft)

application, activating from Excel, 646 product activation technology, 6 tools on the Web, 924 Office 97 (Microsoft) COM add-ins, 669 development, 10 FileSearch object, 819-820 Windows API functions, 313 Office 2000 (Microsoft), 11 Office Web Components (Microsoft). See OWC offset function, 599-601 Offset property, range objects, 182-183 OK button adding automatically, 914 ListBox, activating, 470 modifying to add progress indicator, 479 OLE (Object Linking and Embedding). See also Automation macro Excel, early support, 8 in Registry, 87-88 Visual Basic Editor interface object model, 843-846 VBA, 841-843 on and off switch

GridLines menu display, 755-756 Num Lock key, 867 Toolbox, 412 100 CommandButtons, adding to UserForm,

852-853, 854-856 100 integers, calculating sum of, 189-190

one-dimensional arrays, 336 online help, 770 online resources

Microsoft Technical Support, 923-924 newsgroups, 924-928 Web sites, 881, 928-929 OnTime event, 636-638 Open event, 614-615 opening application with splash screen, 447-449 crash when starting Excel, 885-886 VBA text files, 825

workbook at Excel startup, 69-70, 894 operand, 56 operation performing on all objects in (For Each-

Next construct), 218-220 VBA files, manipulating, 815-816 operators formula, 44

ranges, intersecting, 50-51 VBA support, 208, 892-893 option button controls, interactive charts, 602 Option Explicit,887-888 options asking user to choose among

(GetSaveAsFilename), 398, 913 button formatting, 29 data analysis, 12 font, 152

GetOption function, 861-864 VBA programming, choosing among (Select Case construct), 224-228 Options dialog box

Docking tab, 153-154 Editor Format tab

Code Colors option, 152 displayed, 152 Font option, 152 Margin Indicator Bar option, 153 Size setting, 153 Editor tab

Auto Data Tips option, 151 Auto Indent setting, 151 Auto List Members option, 150 Auto Quick Info option, 151

Auto Syntax Check setting, 149-150 Default to Full Module View option, 152 displayed, 149

Drag-and-Drop Text Editing option, 151 Procedure Separator option, 152 Require Variable Declaration option, 150 General tab, 153 Or operator, 209 OS/2, 8

outline, worksheet, 35 Outlook (Microsoft), 659-660 outsider developers, 95 overwrite protection, 37-38 OWC (Office Web Components) chart control, 500-502 described, 503

interactive workbooks, posting, 34 spreadsheets, adding to UserForm, 504-507

0 0

Post a comment