UEU-co logo

S


Previous Page

Next Page

Index

S

/s switch, 75 SaveAllGraphics procedure, 586-587 SaveAllWorkbooks function, 344 SaveChartAsGIF procedure, 585 SaveDefaults procedure, 812 SaveSetting statement, 980 saving charts as GIF files, 525 files, date, 363-364 workbooks, 344 SayIt function, 363 scope cells, 56 functions, 283 procedures, 239-240 ranges, 56 Scroll event, 661 ScrollBar control, UserForms, 418 ScrollBarZoom_Change procedure, 460 scrolling charts, 618-621 preventing, 950 worksheets, UserForms, 458-460 Search text not found error, 992 Second function, 985 security. See also protection developers and, 13 macros, 938 passwords, 124 Trust Center dialog box, 861 Seek function, 986 Seek statement, 980 Select Case construct, 225-228 Select Case statement, 980 Select event, 603, 654 SelectAllButton_Click procedure, 475 SelectByValue function, 341 SelectCurrentRegion macro, 320 selected cells, counting, 326-327 selected ranges, looping, 329-332 selecting cells by value, 340-342 color, in UserForms, 523-524 directories, Windows API and, 404-406 objects, 32-33 ranges in UserForms, 452-453 rows, ListBoxes and, 474-476 Selection property, 178 SelectionChange event, 645, 651-652 Selection_Change event, 490 Sendasheet procedure, 691 SendAsPDF procedure, 692-693 SendEmailViaOutlookExpress procedure, 693-694 SendKeys method, 693-695 SendKeys statement, 981 SendMail method, 690 SendMail procedure, 687-689 SendOneSheet procedure, 691 SendWorkbook procedure, 691 sequential access, text files, 841 series, charts, hiding, 612-613 SERIES formula, 592-593 SeriesChange event, 603, 654 SERIESNAME_FROM_SERIES function, 596 server application, 677 Set not permitted error, 991 Set not supported at runtime error, 991 Set not supported (read-only property) error, 991 Set statement, 981 SetAlarm procedure, 662 SetAttr command, 830 SetAttr statement, 981 SetElement method, 589 SetSourceData method, 577 Sgn function, 986 shadows, charts, 590-591 Shape object, ChartObject, 575 shapes color, background, 917-919 fills, 919-925 introduction, 38-39 MakeShapeWithGradient procedure, 920 MakeShapeWithPattern procedure, 921 MakeShapeWithPicture procedure, 922 MakeShapeWithText procedure, 924 MakeShapeWithTexture procedure, 923-924 UserForms, 961 SheetActivate event, 638, 640, 656 SheetBeforeDoubleClick event, 638, 656 SheetBeforeRightClick event, 638, 656 SheetCalculate event, 638, 656 SheetChange event, 638, 656 SheetDeactivate event, 638, 656 SheetExists function, 358 SheetFollowHyperlink event, 638, 656 SheetOffset function, 372 SheetPivotTableUpdate event, 638, 656 SheetSelectionChange event, 638, 656 Shell function, 670-672, 986 ShellExecute Windows API function, 672-674 shortcut keys creating, 116-117 macros, 163 shortcut menus adding automatically, 775-776 Cell, new item, 770-772 context-sensitive, creating, 777-779 context-sensitivity, 26 customizing, 26, 116 deleting automatically, 775-776 developers and, 13 disabling, 769 disabling items, 770, 776-777 hiding items, 776-777 icons, 773-774 items, displaying all, 766-768 listing, 762-763 resetting, 768-769 right-clicking, 26 setup, 639 submenus, adding, 772-775 Show method, UserForm object, 427 ShowCaption procedure, 764 ShowChart procedure, 600-601 ShowChartAsGrayScale procedure, 908 ShowComponents procedure, 864-865 ShowDataForm method, 411 ShowDriveInfo procedure, 837-838 ShowGraphic procedure, 673 ShowInstalledFonts macro, 351 ShowShortcutMenuItems procedure, 766-768 ShowShortcutMenuNames procedure, 763 ShowValueRange procedure, 596-597 sign of number, 986 Sin function, 986 sine of numbers, 986 Single data type, 195, 978, 982 single-block budgets, 106 single-user applications, 104 size extended property, 839 Size setting (VBE), 156 SizeAndAlignCharts procedure, 584-585 sizing, ChartObjects, 584-585 slide shows, displaying, 611 SLN function, 986 Smart Tags, 28 SmartArt, 38-39 Solver, 42 sorting arrays, 352-354 procedures, 266-270 SortSheets procedure, 273 SortTester routine, 267 sounds, 963, 977 Space function, 986 spaghetti applications, 104-105 spaghetti code, 229 Spc function, 986 speaking cell contents, 933 SpecialCells method, 258 Specified DLL function not found error, 992 speed of system, 129 SpinButton control TextBoxes and, 441-443 UserForms, 419 spinners, Ribbon, 22-23 splash screen, creating, 454-455 Split function, 370-371, 986 spreadsheet applications. See applications spreadsheets for-your-eyes-only, 104 Lotus 1-2-3, 5-6 Quattro Pro, 7 quick-and-dirty, 103 VisiCalc, 4 Sqr function, 986 square root of numbers, 986 standard programming constructs, 137 StartAmortizationWizard procedure, 806 StartCalc procedure, 670 StartCalculator procedure, 674 StartEmail procedure, 673 StartTextTools procedure, 538 startup actions, 74 StartWord procedure, 675 statements AppActivate, 977 Beep, 977 Call, 977 ChDir, 977 ChDrive, 977 Close, 977 Const, 977 Date, 977 Declare, 978 DefBool, 978 DefByte, 978 DefCur, 978 DefDate, 978 DefDbl, 978 DefDec, 978 DefInt, 978 DefLng, 978 DefObj, 978 DefSng, 978 DefStr, 978 DefVar, 978 DeleteSetting, 978 Dim, 978 Do-Loop, 978 For Each-Next, 979 End, 978 Enum, 979 Erase, 979 Error, 979 On Error, 980 Event, 979 Exit Do, 979 Exit For, 979 Exit Function, 979 Exit Property, 979 Exit Sub, 979 FileCopy, 979 For-Next, 979 Function, 979 Get, 979 GoSub…Return, 979 GoTo, 979 If-Then-Else, 979 Implements, 979 Input, 844 Input #, 844, 979 Kill, 979 Let, 979 Line Input #, 844, 979 Load, 979 Lock…Unlock, 979 Lset, 979 Mid, 979 MkDir, 979 Name, 980 On…GoSub, 980 On…GoTo, 980 Open, 842, 980 Option Base, 980 Option Compare, 980 Option Explicit, 980 Option Private, 980 Print #, 844, 980 Private, 980 processing conditionally, 980 Property Get, 980 Property Let, 980 Property Set, 980 Public, 980 Put, 980 RaiseEvent, 980 Randomize, 980 ReDim, 980 Rem, 980 Reset, 980 Resume, 980 RmDir, 980 RSet, 980 SaveSetting, 980 Seek, 980 Select Case, 980 SendKeys, 981 Set, 981 SetAttr, 981 Static, 981 Stop, 981 Sub, 981 Time, 981 Type, 981 Unload, 981 While…Wend, 981 Width #, 981 With, 981 Write #, 844, 981 StatFunction, 371-372 Static statement, 981 static variables, 202 Statistical functions, category, 308 status bar, hiding, 932 status extended property, 839 Stephen Bullen’s Excel Page Web site, 976 Stop statement, 981 storing code, 145 macros, 163 Str function, 986 StrComp function, 986 StrConv function, 986 String data type, 195, 978, 982 String function, 986 string representation of number, 986 strings alignment, 980 characters, replacing, 979 comparing, 980 converted, 986 converting character code to, 982 converting to lowercase, 984 converting to time serial number, 986 converting to uppercase, 987 fixed-length, 205 leading spaces, 985 number of characters in, 984-985 operating environment, 983 positing in string, 984 repeating, 986 reversed, 986 variable-length, 205 StrReverse function, 986 structured programming, 230 stylistic formatting, 34 Sub or Function not defined error, 990 Sub procedures Ctrl+shortcut key, 242-243 declaring, 238-239 Function procedures and, 276 introduction, 190 Macro dialog box, 241-242 Ribbon and, 243 Run Sub/UserForm command, 241 sub procedures, 145 Sub statement, 981 subject extended property, 839 submenus, adding to shortcut menus, 772-775 Subscript out of range error, 949, 989 subtypes, variables, 987 SUM function, emulating, 301-304 SumArray function, 294 summing formulas, 66 Switch function, 986 SYD function, 986 Sync event, 638 synchronization, worksheets, 346-347 SynchSheets function, 346-347 syntax errors, error-handling and, 255 system date, setting, 977 system requirements, 993 system speed, 129 system time, setting, 981

Previous Page

Next Page

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited