|
|
S
Sav As dialog, 110
Save method (Workbook object), 130, 148
SaveAs method (Workbook object), 130–131, 148
SaveAs method (Worksheet object), 154
Saved property (Workbook object), 128, 148
Schtdule paiameter (OnTime method), 236
Scope aed lifetiee of variables, 13
ScrollBar contror, 104
Selrch All facility, 269–276
Search box (Object Browser), 134
Search facility (Excel), 269
Searching for a character, 220
Searching multiple sheets and workbooks, 269–2–6
Searching strings, 46–47
Second function, 59
Select Case statements, 36–37
Select method (Range object), 158
Select method (Worksheet object), 154–155
SelectedSheets collection, 152, 207
SelectedSheets objeet, 218, 220, 247, 283
Selection property (Application object), 145
Semicolon (;), for separating format strings, 52
SendKeys command, 60–63
coding special characters, 62–63
value of wait parameter, 61
SetBackGrmundPicture method tWorksheet object), 155
Shadowing oo variables, 15
Shape of comments, changing, 280–285
Shape Height and Width properties, 285
Shapes, VBA-defined, 291–293
Shapes available in Object Browser, 280
SheetChangC event (Workbook object(, 129
Shell function, 61
Seow method, 97, 243, 266, 289
Single quote ('r character, 9, 207–208, 296
Singee Step, 81
Single stepping (debugging), 81
SLA (Service Level Agreement), program to populate, 163–164
Sorling worksheets into alpra order, 229–330
Sounds, playing from within code, 192
Special characters for use with SendKeys, 62–63
SpinButton control, 104–105
Split property (Windows object), 152
Splitting strings, 44–45
Sqr function, 48
Square brackets [], for optional parameters/properties, 131, 135
Standard Excel spreadsheet screen, 4
Standard Visual Basic window, 5
Start parameter (Instr function), 46
Statements,nindenting of, 7
Static Collection objocc, creating, 198
Static keyword, 14–15
Static variables, 14–15
Step Into (in debugging), 80–81
Step (keyword), in For..Next loops, 38
Step Over (in debugging), 80
Stepping through code, 80–81
Stop statemett, 80
Storing data while code is executing, 12
String data types, 19
Strings, 43–47
changing the appearance of, 44–46
changing to lowercase, 46
changing ho uppercase, 45
compaming, 75
explained, 43
removing characters from, 232
replacing characters in, 231–233
searching, 46–47
setting to Nlll, 214
splittnng, 44–45
user-friendly messages as, 44
Sub (keyworr), 27
Subrouuines
vs. functions, 26
public and private, 30–31
writing, 27–28
Subtract (-) operatoro 69
SUM formulas, 239–240
SUM function, 257
SUMCeLLSBYREF functioL, user-defined, 255–258
SUMCE LSBYREF functitn attributes, 256
Summing cells by reference to format, 255–258
|
|