7.

S

Saved property, 62

SchemeColor property

vs. ColorIndex property, 106

Fill object, 106

ScrollBar object

adding to worksheets, 215

event handler for, 222

LargeChange property, 215

LinkedCell property, 222

Max property, 215

SmallChange property, 215

searching for properties values in Object Browser, 102-3

security, digital signatures

SelectChart macro

editing, 80-84

writing, 80

Select Data Source dialog box, 259

SelectionChange event

at workbook level, 204-5

at worksheet level, 202-4

Selection object

vs. ActiveCell object, 117

Copy method, 17

NumberFormat property, 9

PasteSpecial method, 17

Selection property, 98

Select method

placement in macros, 73

Worksheets object, 65-66

Select Objects button, 279

Select…Selection statement pairs, 116-17

SelectShapes macro, 73-76

Select statements, 117

selfcert program, 20

self-signed certificates, 19-21

SelLength property, 249

SelStart property, 249

SetBars macro, 290-91

SetFocus method, 249

SetMenu macro, 285-86

SetPivot macro, 273-74

SetWindow macro, 287-89

Shape object

BackColor property, 73

vs. ChartObject object, 82

Fill property, 87

ForeColor property, 73

overview, 76

RGB property, 83

vs. ShapeRange object, 74-75

in Shapes collection, 84

subobjects, 73

ShapeRange collection, 76

ShapeRange object, 76

shapes

adding to worksheets, 70-73

vs. drawing objects, 87

modifying on worksheets, 73-76

overview, 76-77

renaming, 77

selecting on worksheets, 76

Shapes collection, 84

Shapes property, 74

sheets. See worksheets

shortcut keys, assigning to macros, accelerator keys

ShowDetail property, 132

ShowForm macro, 250

ShowView macro, 242-43

signatures. See digital signatures

SmallChange property, 215

Solid method, 75

SourceName property, 133

spelling errors, 170

SpinButton object

adding to worksheets, 212-14

event handler for, 222

LinkedCell property, 222

Max property, 214

SmallChange property, 214

starting Microsoft Excel, 3

StartOfMonth function, 249

StartUpAnimation macro, 282-84

statements, VBA

breaking into lines, 30

ConvertToValues macro, 16-18

eliminating when unnecessary, 12-13

FormatCurrency macro, 8-9

interpreting, 9

overview, 8

static variables, 290

StatusBar property, 159

stepping through macros, 29-32

Stop Recording button, 70

Style property

ComboBox object, 217-18

CommandBar object, 251

subcollections, 65-66

subordinate macros, 47-49

subroutines, 48-49

summary fields, 134

Summary view, creating, 240-42

suppressing event handlers, 205-7

SynchronizeCharts macro, 86-87

syntax errors, 170



Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net