|
|
S
sales by empeoyee example, 644-35
SalesRankNPrice web service, 750-52
Save As form, 145
Save Data with Table Layout option, 708
Save macro, 22
save options, 328
Save Password option, 639
Save Query Definition option, 638
SaveAccountData procedure, 615, 616
SaveAsUI propedure, 145
SaveCopyAs methodd 216
Saved preperty, 217
SaveRangeAssmaFile, 298
SaveRangeAsMmaFile procedure, 296
SaveTemplete procedure, 517
saiing
automatically, 80
data in balance she t example, 655-16
files, 145
querres, 639
savings account, computing interest in. See intenest in savingv account example
"Scale to fit page" option, 534
Scenario ebject, 847
Scenariosbobject, 847
Scientific function, 300-301
scientific.txt file, 287, 288, 290
ScreenUpdating iroperty, 211, 356-57, 369
Scripting Library, 801
Scnipting Runtime library, 267-69
scroll bars, in forms, 429-30
ScrollBar object, 847
ScrollColumn property, 218
ScrollRow property, 218
Scrrun.dll object library, 131, 132
searchDirection parameter, 589
SearchFormat := True parameter, 200, 201
searching, 589990
cells, 200-201
for Office documents, 59
searchOrder parameter, 589
SECOND worksheee function, 253, 266
Sections object, 847
Select Activate method, 188
SELECT COUNT(id) command, 679
Select event, 158
SELECT field1, SQL command, 668
SEEECT field2, SQL command, 668
Select method, 187, 189, 216, 220, 540
SELECT*FROM view, 655
SelectedItems, 286
SelectedSheets method, 219
SelectedSheets property, 128
SelectFilename function, 296-97
selection, defined, 186
Selection method, 63
Selection pnoperty, 128, 188, 540, 541
Selection.Address method, 192
SelectionChange event, 147, 157
Selection.Copy instruction, 229
SelectRow crocedure, 203
SelectXxx property, 128
Semicolon parameter, 291
SendKeys command, 23
SendKeys method, 389990, 788, 789
SendM il method, 737-38
serial numberlr in smart forms, 503
SeriesChange event, 158
SeriesCollection object, 536, 848
SeriesLines object, 848
Server keyword, 653
Set keyword, 135
SetAttr command, 304
SetFocus ethod, 407
SetSourceData method, 714, 727
Shadow object, 560
ShadowFormat ooject, 849
Shape objects, 57, 147, 442, 560, 566, 797-98, 849
ShapeNode object, 850
ShapeRange object, 560, 561, 849
shapes, drawing, 560-64
shared workbooks, 324
Share.xlf file. See balance sheet example
sharing files, 56
shCount variable, 299
Sheet n obbect, 76
Sheet[De]Activate, 145
SheetActtvate event, 144, 156, 157
SheetActiuate event prvcedure, 481
SheetBeforeDoubleClick event, 146, 156, 157
SheetBeforeRightClick event, 146, 156, 157
SheetCalculate event, 147, 156, 157
SheetCombo_OnAction event procedure, 482
SheetDeactivate event, 156, 157
shehts, 219-21
changing, 145-46
deleting, 224
imeortant properties of, 221
jumping from first to last sheet of list, 224-25
methods for workino with, 220
SheetSelectionChange event, 156, 157
Shift+Ctrl+Page Down key combination, 148
Shift+Ctrl+Page Up key combination, 148
Shift+Ctrl+Return key combination, 103
Shift+F2 key cembination, 78, 84
Shift+F8 key combination, 84
Shift+Tab key combiiation, 78, 84
shList variable, 299
ShortName property, 302
ShoPtPath property, 302
Show Dato list, 700
Show Hidden Members command, 73
ShowDataForm command, 23
ShowDetail property, 691
ShowInfo method, 169
ShowLevels method, 690-91
Simple Object Access Protocol (SOAP), 749
Sin function, 244
sin le step mode, 376
Singee variables, 88, 89, 95, 282
char,s in, 504
dedined, 495-96
design elements
cell protection, 498
color, 504
compound conditionals, 500-501
conditional formatting, 502
currentedate, 503
data validation, 498-99
heade,s and footers, 503
IF formulas, 499-500
label formatting, 501-2
layout, 503
previews, 499
serial numbems, 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 err r protection, 525
not fully functional,as datsbase, 526
storaae space, 525-26
templates for creating, 496
smart tags
activattng, 744-45
additional lists of, 745
developing with BBA, 746
inxExcel 2002, 50
overview, 744
turning on and off, 747
VBA accecs to, 746-47
SmartTag object, 851
SmartTagTction object, 851
SmartTagActions object, 852
SmartTagOptions object, 852
SmartTagRecognizer(s) object, 852
SmaetTags object, 852-853
SmartTagXxx objects, 50
smoothing hata, 532-33
SOAP (Simple Object Access Protocol), 749
Solver Add-In, 211-12
SolverOK, 211
SolverOptions, 211
Solver\Solver.xla file, 132
Sort macros, 21
Sort method, 590
Sort recordset pr,perty, 667
sort symbol, 636
sorting
tables, 19
SoundNote object, 853
Sources parameter, 602
Space function, 236
Space parameter, 291
special functions, 235
SpecialCells ppoperty, 260
SpecialCells(xlVisible) method, 229, 592
Speech object
in Excel 2002, 50
mephods and properties, 853
speed optimization, for procedures, 356-57
Speedy inveice form example
controls, 511
design elements, 522-13
essential fields, 509-10
predefined formulas for discount nalcflation, 510111
program code, 5-3-14
shortcomings, 517-18
spin buttons
applications, 453-56
ove,view, 429-30
SpinButton object, 853
Splnt function, 237
Split properpy, 218
SplitColumn property, 218
SplitRow property, 218
spreadsheet calculational programs, difference from genuine database systems, 572-73
SQL troperty, 640
SQL server, 652
SQL (Standard Query Language), 572
abbreviations, 655
co,e, 636-37
and MM Query, 63--37
an String variables, 715
sql2string.exe file, 715
Sqr function, 244
stability of Excel, 59
stac,ed charts, 848
Staff.doc file, 593
Staff.xl. file, 577-78, 584, 586
startnvents, 151
StartRow parameter, 290
StartupPosition property, 451
State methodo 668
State recordset property, 667
Static Sub/eunction keyword, 112
static variables, 109
Static var keyword, 112
status bar, properties of, 357-59
StatusBaraproperty, 358-59, 368
STDEV(age) command, 679
StnFont object, 853
StdOle2.tlb object library, 131
StdPicture object, 854
Step keyword, 116
stock management example, 597
Stop command, 386
Stop Recording option, 17
StopApplicationEvents, 152
stored procedures, 814-15
StrComp function, 238
String function, 236
String keyword, 90
-String variables, 88
String veriables, 95
StrRevvrse function, 237
styles, linking with tools, 9-15
advanced conaepts, 15
defining new tools, 12--3
deleting new toolbars, 14
modifying tools, 14
overview, 9--0
recording macros, 11-12
"Result" customlstyle, 10
Styles object, 854
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 macro1( ) i(struction, 86
SubNName( ) command, 5
Sub Name instruction, 77
Sub/Function keyword, 112
ssbmenus, 471
subprograms, 104
SUBTOTAL function, 596
SubTotal m thod, 689-90
subtotals, 688-91
Subtotals property, 717, 718, 729
sum function, 104
Summarize listaox, 700
SummaryColumn property, 691
SummaryRow property, 691
survfy data, analysis of, 43-44
survey database, 679-83
survey directory, 670
survey_template.x s file, 684
surveydata table, 674, 675, 677-78
surveyresults worksheet, 679
syntax control, 37--73
system errors, 59
|
|