sales by employee example, 634-35
SalesRankNPrice web service, 750-52
Save Data with Table Layout option, 708
Save Password option, 639
Save Query Definition option, 638
SaveAccountData procedure, 615, 616
SaveRangeAsMmaFile procedure, 296
SaveTemplate procedure, 517
saving
automatically, 80
data in balance sheet example, 615-16
files, 145
queries, 639
savings account, computing interest in. See interest in savings account example
"Scale to fit page" option, 534
Scientific function, 300-301
scientific.txt file, 287, 288, 290
ScreenUpdating property, 211, 356-57, 369
Scripting Runtime library, 267-69
scroll bars, in forms, 429-30
ScrollArea property, 319, 326
ScrollColumn property, 218
Scrrun.dll object library, 131, 132
searchDirection parameter, 589
SearchFormat := True parameter, 200, 201
searching, 589-90
cells , 200-201
for Office documents, 59
searchOrder parameter, 589
Second function, 250, 266
SECOND worksheet function, 253, 266
Seek command, 278, 279, 305
SELECT * FROM table, 655, 675
Select Activate method, 188
Select Case keyword, 114, 115
SELECT COUNT(id) command, 679
SELECT field1, SQL command, 668
SELECT field2, SQL command, 668
SELECT INTO command, 666, 668
Select method, 187, 189, 216, 220, 540
SelectedSheets method, 219
SelectedSheets property, 128
SelectFilename function, 296-97
Selection property, 128, 188, 540, 541
Selection.Address method, 192
SelectionChange event, 147, 157
Selection.Copy instruction, 229
SendKeys method, 389-90, 788, 789
serial numbers , in smart forms, 503
Series object, 536, 539, 848
SeriesCollection object, 536, 848
SetSourceData method, 714, 727
Shape objects, 57, 147, 442, 560, 566, 797-98, 849
ShapeNodes object, 560, 850
ShapeRange object, 560, 561, 849
Shapes object, 560-64, 850
ShareName property, 269, 302
Share.xlt file. See balance sheet example
SheetActivate event, 144, 156, 157
SheetActivate event procedure, 481
SheetBeforeDoubleClick event, 146, 156, 157
SheetBeforeRightClick event, 146, 156, 157
SheetCalculate event, 147, 156, 157
SheetChange event, 156, 157
SheetCombo_OnAction event procedure, 482
SheetDeactivate event, 156, 157
sheets, 219-21
changing, 145-46
deleting, 224
important properties of, 221
jumping from first to last sheet of list, 224-25
methods for working with, 220
SheetSelectionChange event, 156, 157
Shell command, 786-88, 789
Shift+Ctrl+Page Down key combination, 148
Shift+Ctrl+Page Up key combination, 148
Shift+Ctrl+Return key combination, 103
Shift+F2 key combination, 78, 84
Shift+F8 key combination, 84
Shift+Tab key combination, 78, 84
Show Hidden Members command, 73
Show method, 388, 389, 434
ShowDataForm method, 391, 591
ShowLevels method, 690-91
ShowNewWord procedure, 36, 38
ShowPopup method, 477, 483
Simple Object Access Protocol (SOAP), 749
Single variables , 88, 89, 95, 282
SkipLine method, 276, 303
smart forms
charts in, 504
defined, 495-96
design elements
cell protection, 498
color , 504
compound conditionals, 500-501
conditional formatting, 502
current date, 503
data validation, 498-99
headers and footers, 503
IF formulas, 499-500
label formatting, 501-2
layout, 503
previews, 499
serial numbers, 503
templates, 497-98
embedded formulas in, 496
examples
car-sharing club balance sheet, 518-25
Speedy invoice form, 509-18
included with Excel, 509
integrating controls into, 504
sample uses, 497
separating template from code, 525
shortcomings
input error protection, 525
not fully functional as database, 526
storage space, 525-26
templates for creating, 496
smart tags
activating, 744-45
additional lists of, 745
developing with VBA, 746
in Excel 2002, 50
overview, 744
turning on and off, 747
VBA access to, 746-47
SmartTagAction object, 851
SmartTagActions object, 852
SmartTagOptions object, 852
SmartTagRecognizer(s) object, 852
SmartTags object, 852-853
SOAP (Simple Object Access Protocol), 749
Solver\Solver.xla file, 132
Sort recordset property, 667
sorting
data, 581-82, 590
tables, 19
SpecialCells method, 191, 203
SpecialCells property, 260
SpecialCells(xlVisible) method, 229, 592
Speech object
in Excel 2002, 50
methods and properties, 853
speed optimization, for procedures, 356-57
Speedy invoice form example
controls, 511
design elements, 512-13
essential fields, 509-10
predefined formulas for discount calculation, 510-11
program code, 513-14
shortcomings, 517-18
spin buttons
applications, 453-56
overview, 429-30
SplitColumn property, 218
spreadsheet calculational programs, difference from genuine database systems, 572-73
SQL (Standard Query Language), 572
abbreviations, 655
code, 636-37
commands, 625, 662-66
and MS Query, 636-37
and String variables, 715
Staff.xls file, 577-78, 584, 586
StartupPath property, 52, 284
StartupPosition property, 451
State recordset property, 667
Static Sub/Function keyword, 112
status bar, properties of, 357-59
StatusBar property, 358-59, 368
StdOle2.tlb object library, 131
stock management example, 597
Stop Recording option, 17
StopApplicationEvents, 152
stored procedures, 814-15
Style object, 195-96, 854
Style property, 195, 196, 469
styles, linking with tools, 9-15
advanced concepts, 15
defining new tools, 12-13
deleting new toolbars , 14
modifying tools, 14
overview, 9-10
recording macros, 11-12
"Result" custom style, 10
Sub Auto_Add( ) End Sub procedure, 156
Sub Auto_Close( ) End Sub procedure, 156
Sub Auto_Open( ) End Sub procedure, 156
Sub Auto_Remove( ) End Sub procedure, 156
Sub instruction, 140, 155
Sub macro1( ) instruction, 86
SubFolders property, 273, 302
Sub/Function keyword, 112
Subtotals property, 717, 718, 729
SummaryColumn property, 691
Supports method, 657, 667
survey data, analysis of, 43-44
survey worksheet, 674, 684
survey_template.xls file, 684
surveydata table, 674, 675, 677-78
surveyresults worksheet, 679
survey.xls file, 670, 672-73