108
Sequence Wizard,399,401
Seriescollection,188,189,192–194,196,203,204,
220,221,366,422,694,695,703,734,742,769,
839,842,876
Series formats,691
SERIESfunction,191,193–195,197
Seriesobject,187,197,694,703,729,769,840,
872–877,917
SeriesChangeevent,Chartobject,695
SeriesCollectioncollection,872–877
SeriesCollectionmethod
Chartobject,694
SeriesCollectionobject,873
SeriesCollectionobject,187,197,742
SeriesLinesobject,877
ServerActionsproperty,Rangeobject,856
ServerPolicyproperty,Workbookobject,942
ServerViewableItemscollection,878
ServerViewableItemsproperty,Workbookobject,942
Setstatement,20,45,69,134,356
SetBackgroundPicturemethod,Worksheetobject,962
SetBackgroundPictureStringmethod,Chart
object,694
SetDefaultChartStringmethod,Chartobject,694
SetDefaultContextmethod,IAssistanceobject,1039
SetEditingTypemethod,ShapeNodeobjects
collection,886
SetElementmethod,186,187,694
SetExtrusionDirectionmethod,ThreeDFormat
object,913
SetFirstPrioritymethod
AboveAverageobject,638
Top10object,916
UniqueValuesobject,920
SetFocusmethod
CommandBarButtonobject,1006
CommandBarComboBoxobject,1009
CommandBarControlobject,1013
CommandBarPopupobject,1015
Windowobject,993
SetIconmethod,SortFieldsobject,898
SetLastPrioritymethod
AboveAverageobject,638
Top10object,916
UniqueValuesobject,920
SetLinkOnDatamethod,Workbookobject,950
SetParammethod,479
SetPasswordEncryptionOptionsmethod,Workbook
object,950
SetPhoneticmethod,Rangeobject,864
SetPositionmethod,ShapeNodeobjects collection,886
SetPresetCameramethod,ThreeDFormatobject,913
SetRangemethod,143,146,897
SetSegmentTypemethod,ShapeNodeobjects
collection,886
SetSelectionmethod,CodePaneobject,979
SetShapesDefaultPropertiesmethod
Shapeobject,885
ShapeRangeobject,891
SetSourceDatamethod,177,184,187
SetSourceDataRangemethod,Chartobject,694
SetThreeDFormatmethod,ThreeDFormatobject,913
Setup buttons,687,693
Setupproperty,Signatureobject,1062
SetupBlogAccountmethod,IBlogExtensibility
object,1040
SetUpMenus procedure,351
SetValuemethod,XPathobject,970
SetWindowLongfunction,623
SFIcontrols,496
sFormatDatefunction,567
Shadow format,700,710
Shadowproperty
AxisTitleobject,675
ChartAreaobject,697
Font2object,1036
Seriesobject,875
ShapeRangeobject,889
Shadowproperty,Shapeobject,883
ShadowFormatobject,878–879
Shapeobject,65,177,178,184,186,187,640,680,
707,715,717,719,744,753,757,775,776,791,
793,795,806,878,880–885,907,911
ShapeNodeobject,886–887
ShapeNodescollection,886–887
ShapeRangeobject collection,887–891
ShapeRangeobjects,908
Shapescollection,177,181,192,196,757,880–885
Shapesproperty
Chartobject,689
Worksheetobject,957
ShapeStyleproperty
Shapeobject,883
ShapeRangeobject,889
sharedStrings XMLfile,268–269
SharedWorkspaceobject,1054–1055
SharedWorkspaceproperty,Workbookobject,942
SharedWorkspaceFileobject,1055–1056
SharedWorkspaceFilescollection,1055–1056
SharedWorkspaceFolderobject,1057
SharedWorkspaceFolderscollection,1057
SharedWorkspaceLinkobject,1058–1059
SharedWorkspaceLinkscollection,1058–1059
SharedWorkspaceMemberobject,1059–1060
SharedWorkspaceMemberscollection,1059–1060
SharedWorkspaceTaskobject,1060–1061
1130
Sequence Wizard
110
SharedWorkspaceTaskscollection,1060–1061
Sheetobject,77,90
Sheetproperty
PublishObjectobject,845
WorksheetViewobject,967
SheetActivate event
Applicationobject,661
Workbookobject,952
SheetBeforeDoubleClickevent
Applicationobject,661
Workbookobject,952
SheetBeforeRightClickevent
Applicationobject,661
Workbookobject,952
SheetCalculateevent
Applicationobject,661
Workbookobject,952
SheetChangeevent,206,661
SheetChangeRangeevent,Workbookobject,952
SheetDeactivateevent
Applicationobject,662
Workbookobject,952
SheetFollowHyperlinkevent
Applicationobject,662
Workbookobject,953
SheetPivotTableUpdateevent
Applicationobject,662
Workbookobject,953
Sheetscollection
Copyand Movemethods,85–87
grouping worksheets,87–88
overview,891
Sheets common properties,891
Sheetsmethods,892–893
Sheets properties,892
Worksheetscollection,83–85
Sheetsproperty
Applicationobject,653
Workbookobject,942
SheetSelectionChangeevent
Applicationobject,662
Workbookobject,953
SheetsInNewWorkbookproperty,Application
object,653
SheetViewsobject,893
SheetViewsproperty,Windowsobject,932
SHELL32.DLLfile,602
ShiftButtonparameter,695
Shiftparameter,695
ShipperIDfield,458
shortcut keys,for macros,6–7
Shortcut menus,319,338,340,352
shortcut Rangeobject references,96
ShortcutTextproperty,CommandBarButtonobject,1004
ShortDate format,539,541,549
ShowDependentsmethod,Rangeobject,865
Showmethod
CodePaneobject,979
DialogSelecteditemsobject,235
FileDialogobject,1033
UserForm,273
WorkflowTaskobject,1077
WorkflowTemplateobject,1078
Show pages command,512
Showparameter,690
ShowAllDatamethod
AutoFilterobject,668
Worksheetobject,962
ShowAsAvailableproperty,TableStyleobject,905
ShowAsAvailableTableStyleproperty,TableStyle
object,905
ShowAutoFilterproperty,148
ShowChartTipNamesproperty,Applicationobject,653
ShowChartTipValuesproperty,Application
object,653
ShowConflictHistoryproperty,Workbookobject,942
ShowDataFormmethod,128,159,556,962
ShowDataLabelsOverMaximumproperty,Chart
object,689
ShowDetailproperty,828,856
ShowDetailsmethod,Signatureobject,1063
ShowDevToolsproperty,Applicationobject,653
ShowErrorproperty,Validationobject,923
ShowErrorsmethod,Rangeobject,865
ShowHelpmethod,IAssistanceobject,1039
showImageattribute,302
ShowImportExportValidationErrorsproperty,
XmlMapobject,968
ShowInputproperty,Validationobject,923
showItemImageattribute,302,305
showItemLabelattribute,302
showLabelattribute,303
ShowMenuFloatiesproperty,Applicationobject,653
ShowPivotChartActiveFieldsproperty,Workbook
object,942
ShowPivotTableFieldListproperty,Workbook
object,942
ShowPopupmethod,342,1002
ShowPrecedentsmethod,Rangeobject,865
ShowSelectionFloatiesproperty,Application
object,653
ShowSettingsmethod,EncryptionProvider
object,1031
1131
ShowSettings method,EncryptionProvider object
I
n
d
e
x
VB Imaging - VB MSI Plessey Barcode Tutorial barcode.Resolution = 96 'set rotation barcode.Rotate = Rotate.Rotate0 barcode It allows you to select one page from a Below is just an example of generating an
rotate all pages in pdf and save; how to rotate all pages in pdf
106
ShowSignatureAddedmethod,SignatureProvider
object,1065
ShowSignatureCertificatemethod,SignatureInfo
object,1064
ShowSignatureDetailsmethod,SignatureProvider
object,1065
ShowSignatureSetupmethod,SignatureProvider
object,1065
ShowSignaturesPaneproperty,SignatureSet
collection,1062
ShowSignDateproperty,SignatureSetupobject,1066
ShowSigningCeremonymethod,SignatureProvider
object,1065
ShowStartupDialogproperty,Applicationobject,653
ShowToolTipsproperty,Applicationobject,653
ShowWindowfunction,623
ShowWindowsInTaskbarproperty,Application
object,653
ShrinkToFitproperty
CellFormatobject,683
Rangeobject,857
Styleobject,902
ShtAsobject,89,90,324
Shtparameter,91
SideWallproperty,Chartobject,690
Signmethod,Signatureobject,1063
Signatureobject,1061–1063
SignatureCommentproperty,SignatureInfo
object,1064
SignatureImageproperty,SignatureInfoobject,1064
SignatureInfoobject,1063–1064
SignatureLineShapeproperty,Signatureobject,1063
SignatureProviderobject,1064–1066
SignatureProviderproperty
SignatureInfoobject,1064
SignatureSetupobject,1066
Signaturesproperty,Workbookobject,942
SignatureSetcollection,1061–1063
SignatureSetupobject,1066
SignatureTextproperty,SignatureInfoobject,1064
SigningInstructionsproperty,SignatureSetup
object,1066
SignXmlDsigmethod,SignatureProviderobject,
1065
Simpleclass,384,385,401,408
single-parameter Rangeobject reference,101–102
sizeattribute,303
Sizeparameter,691,708
Sizeproperty
Font2object,1036
ShadowFormatobject,879
Sizeableproperty,625
sizeStringattribute,303
Smallcapsproperty,Font2object,1036
SmallScrollmethod,Windowsobject,935
SmartDocumentobject,1066–1067
SmartDocumentproperty,Workbookobject,942
SmartTagobject,893–894
SmartTagActionobject,894–895
SmartTagActionscollection,894–895
SmartTagActionsproperty,SmartTagobject,894
SmartTagOptionscollection,895
SmartTagOptionsproperty,Workbookobject,942
SmartTagRecognizersRecognizersproperty,
Applicationobject,653
SmartTagReconizerobject and SmartTagRecognizers
collection,895–896
SmartTagscollection,893–894
SmartTagsproperty
Rangeobject,857
Worksheetobject,957
Smoothproperty,Seriesobject,875
sNumToUSfunction,542–543
SoftEdgeFormatproperty,Font2object,1036
SoftEdgeproperty
Shapeobject,883
ShapeRangeobject,889
SoftEdgeFormatobject,1067
Solidmethod,ChartFillFormatobject,699
SolutionIDproperty,SmartDocumentobject,1067
SolutionURLproperty,SmartDocumentobject,1067
SolveOrderproperty,CalculatedMemberobject,679
Sortfieldscollection,143
Sortmethod,Rangeobject,144,865
Sortobject,143,144,146,896–897
Sortproperty
AutoFilterobject,668
Worksheetobject,957
SortFieldobject,143,146,897–898
SortFieldscollection,897–898
SortFieldsproperty,Sortobject,896
SortHintproperty,Signatureobject,1063
sorting
ranges,142–144
tables,145–146
SortMethodproperty,Sortobject,896
SortOnproperty,SortFieldsobject,897
SortOnValueproperty,SortFieldsobject,897
Sortproperty,QueryTableobject,848
SortSpecialmethod,Rangeobject,866
SoundNoteobject,898
SoundNoteproperty,Rangeobject,857
Source argument,443
Sourcefile,270,271
1132
ShowSignatureAdded method,SignatureProvider object
C# Imaging - C# MSI Plessey Barcode Tutorial Resolution = 96;// set resolution barcode.Rotate = Rotate.Rotate0;// set It allows you to select one page from a PDF Below is just an example of generating an
permanently rotate pdf pages; rotate pdf page and save
111
Sourceparameter,694
Sourceproperty
PublishObjectobject,845
Watchobject,927
Sourcetypeparameter,180
SourceConnectionFileproperty,QueryTable
object,848
SourceDataFileproperty,QueryTableobject,848
SourceNameproperty,CalculatedMemberobject,679
SourceTypeproperty,PublishObjectobject,845
SourceURLproperty,967,1055
SpaceAfterproperty,ParagraphFormat2object,1048
SpaceBeforeproperty,ParagraphFormat2object,1048
SpaceWithinproperty,ParagraphFormat2object,1048
Spacingproperty
Font2object,1036
TextColumn2object,1069
Speakmethod
Rangeobject,866
Speechobject,899
SpeakCellOnEnterproperty,Speechobject,898
special names,128–129
SpecialCellsmethod,87,105–107,113,123,124
SpecialCellsmethod,Rangeobject,866
Speechobject,898–899
Speechproperty,Applicationobject,654
SpellingOptionscollection,899–901
SpellingOptionsproperty,Applicationobject,654
SpinButtoncontrol,211–212
SpinDownevent,211,212
SpinUpevent,211,212
Splitfunction,230
Splitproperty,Windowsobject,932
SplitColumnproperty,Windowsobject,932
SplitHorizontalproperty,Windowsobject,932
SplitRowproperty,Windowsobject,932
SplitVerticalproperty,Windowsobject,932
SQL (Structured Query Language) overview
DELETEstatement,435
INSERTstatement,434
UPDATEstatement,434–435
SQL command,440,808
SQLproperty,785,788
SQL Server,using ADO with,454–463
connecting to SQL Server,455–456
disconnected recordsets,461–463
multiple recordsets,460–461
stored procedures,456–460
SSO database,786,790
Standard toolbar,9,27,320,321,580
StandardFontproperty,Applicationobject,654
StandardFontSizeproperty,Applicationobject,654
StandardHeightproperty,Worksheetobject,957
StandardWidthproperty,Worksheetobject,957
Startparameter,174,684,715,805
Startproperty,TextRange2object,1070
Start Recording button,4
StartupPathproperty,Applicationobject,654
StartValueproperty,BulletFormat2object,996
Stateproperty
CommandBarButtonobject,1004
Connectionobject,438
Recordsetobject,443
Statementproperty,ServerPolicyobject,1050
Staticstatement,41
Statusproperty
RoutingSlipobject,870
SharedWorkspaceTaskobject,1061
Syncobject,1068
StatusBarproperty,70,654
Step option,53
Stop Recording button,4
StopifTrueproperty
AboveAverageobject,637
Top10object,916
UniqueValuesobject,920
stored procedures,456–460
StoreLicensesproperty,Permissionobject,1049
Strfunction,542
Streamobject,436
Strikeproperty,Font2object,1036
StrikeThroughproperty,Font2object,1036
String (fixed-length)data type,43
String (variable-length)data type,43
StripeSizeproperty,TableStyleElement,906
Structured Query Language (SQL) overview
DELETEstatement,435
INSERTstatement,434
UPDATEstatement,434–435
structures,606–609
structuring data,141–142
Stylemethod,Styleobject,903
Styleobject,676,901–903
Styleproperty
BulletFormat2object,997
CommandBarButtonobject,1005
CommandBarComboBoxobject,1008
Rangeobject,857
ShadowFormatobject,879
Stylescollection,901–903
Stylesproperty,Workbookobjectcollection,942
sub procedures,calling,35–36
Subjectproperty,RoutingSlipobject,870
SubscribeTomethod,Rangeobject,866
1133
SubscribeTo method,Range object
I
n
d
e
x
VB.NET Word: How to Process MS Word in VB.NET Library in .NET How to Rotate, Merge Word Documents Within VB.NET Imaging the length of the web page, here we just describe each single or multiple Word pages at one time with
how to rotate pdf pages and save permanently; how to rotate one page in pdf document
103
Subscriptproperty,Font2object,1037
Subsetproperty,SignatureSetcollection,1062
Subtotalmethod,Rangeobject,867
SuggestedSignerproperty,SignatureSetup
object,1066
SuggestedSignerEmailproperty,SignatureSetup
object,1066
SuggestedSignerLine2property,SignatureSetup
object,1066
SuggestMainOnlyproperty,SpellingOptions
collection,900
SUMfunction,111
Sum Wizard,639
Summaryproperty,Rangeobject,857
supertip,303,1001
supertipattribute,303
Switch Row/Column button,182
Syncobject,1067–1068
Syncproperty,Workbookobject,943
SyncEventevent,Workbookobject,953
synchronizing worksheets,90–91
SynchScrollingSideBySideproperty,Windows
object,929
T
Tabobject,690,903–904
Tabproperty
Chartobject,690
Worksheetobject,957
tab sets,controlling using RibbonX,313–314
Table button,144
Table feature,129
Tablemethod,Rangeobject,867
table-driven command bar creation,344–353
TableNameparameter,165
tables
creating,144–145,417
sorting,145–146
Tables group,144,162
TableStyleelement,748,765
TableStyleobject,904–906
TableStyleElementobject,906
TableStyleElementscollection,906
TableStyleElementsproperty,TableStyle
object,905
TableStylescollection,904–906
TableStylesproperty,Workbookobject,943
TabRatioproperty,Windowsobject,932
tabs,controlling using RibbonX,313–314
TabStop2object,1068–1069
TabStopsproperty
ParagraphFormat2object,1048
Ruler2object,1051
TabStops2collection,1068–1069
tagattribute,303
Tagproperty
and Clickevents,398,577
CommandBarButtonobject,1005
CommandBarComboBoxobject,1008
CommandBarControlobject,1012
CommandBarPopupobject,1015
and Parameterproperty,333
Tagproperty,IRIbbonControlobject,1042
TakeFocusOnClickproperty,15
TargetBrowserproperty,WebOptionsobject,929
TargetFile variable,266
task panes,showing UserForms as,405–406
Tasksproperty,SharedWorkspaceobject,1055
Taxfunction,47
template letter,425,427,429
TemplateRemoveExtDataproperty,Workbook
object,943
TemplatesPathproperty,Applicationobject,654
Temporaryparameter,400
Terminate code,614
Terminateevent,577,615,619
= TEXT( ) worksheetfunction,559
Application.ConvertFormulafunction,560
Application.Evaluatefunction,560
Application.ExecuteExcel4Macrofunction,560
Range.AdvancedFiltermethod,559–560
Range.Formulaproperty,559
Range.FormulaArrayproperty,559
Range.Valueproperty,559
TextBoxcontrol,276
text files
importing,223,849,850
opening,223
querying,467–468
reading,226–227
writing to,224–233,227
Text for Boolean True setting,538
Text Import Wizard,555,560,561
Textobject,758
Textparameter,658,715,720
Textproperty
AxisTitleobject,675
Charactersobject,685
CommandBarComboBoxobject,1008
CustomXMLNodeobject,1018
CustomXMLValidationError,1024
Rangeobject,857
1134
Subscript property,Font2 object
111
TextEffectFormat,907
TextRange2object,1070
TextBoxcontrol,371
TextBoxobject,369
TextboxTextproperty,SmartTagActionobject,895
TextCode page,693
TextColumn2object and TextColumns2collection,1069
TextDirectionproperty
ParagraphFormat2object,1049
TextColumn2object,1069
TextEffectproperty
Shapeobject,883
ShapeRangeobject,889
TextEffectFormatobject,907–908
TextFileColumnDataTypesproperty,QueryTable
object,849
TextFileCommaDelimiterproperty,QueryTable
object,849
TextFileConsecutiveDelimiterproperty,
QueryTableobject,849
TextFileDecimalSeparatorproperty,QueryTable
object,849
TextFileFixedColumnWidthsproperty,QueryTable
object,849
TextFileOtherDelimiterproperty,QueryTable
object,849
TextFileParseTypeproperty,QueryTableobject,849
TextFilePlatformproperty,QueryTableobject,849
TextFilePromptOnRefreshproperty,QueryTable
object,849
TextFileSemicolonDelimiterproperty,QueryTable
object,849
TextFileSpaceDelimiterproperty,QueryTable
object,849
TextFileStartRowproperty,QueryTableobject,849
TextFileTabDelimiterproperty,QueryTable
object,850
TextFileTextQualifierproperty,QueryTable
object,850
TextFileThousandsSeparatorproperty,QueryTable
object,850
TextFileTrailingMinusNumbersproperty,
QueryTableobject,850
TextFileVisualLayoutproperty,QueryTable
object,850
TextFrameobject,908–909
TextFrameproperty
Shapeobject,883
ShapeRangeobject,889
TextFrame2object,909–911
TextFrame2property,ShapeRangeobject,889
TextRangeproperty,TextRange2object,910
TextRange2object,1070–1072
TextToColumnsmethod,Rangeobject,867
TextureNameproperty,ChartFillFormatobject,699
TextureTypeproperty,ChartFillFormatobject,699
Themeproperty,Workbookobject,943
ThemeColorobject,1072
ThemeColorproperty,676,677,749,750,766,904
ThemeColorSchemeproperty,OfficeThemeobject,1047
ThemeColorSchemeIndexproperty,ThemeColor,1072
ThemeColorsSchemeobject,1072–1073
ThemeEffectSchemeobject,1073
ThemeEffectSchemeproperty,OfficeThemeobject,1047
ThemeFontobject and ThemeFontscollection,1073–1074
ThemeFontSchemeobject,1074
ThemeFontSchemeproperty,OfficeThemeobject,1047
Thicknessproperty,Wallsobject,926
ThisCellproperty,Applicationobject,654
ThisWorkbookproperty,Applicationobject,654
Thousand Separator setting,538
ThousandsSeparatorproperty,Applicationobject,654
ThreeDformatobject,701,710
ThreeDproperty
Shapeobject,883
ShapeRangeobject,889
TextFrame2object,910
ThreeDFormatobject,911–913
ThrottleIntervalproperty,RTD,870
ThunderDFrameclass,608
ThunderRT6DFrameclass,608
ThunderXFrameclass,608
TickLabelPositionproperty,Axisobject,673
TickLabelsobject,913–915
TickLabelsproperty,Axisobject,673
TickLabelSpacingproperty,Axisobject,673
TickLabelSpacingIsAutoproperty,Axisobject,673
TickMarkSpacingproperty,Axisobject,673
Timeparameter,661
Timeproperty,AutoRecoverobject,669
Timerfunction,616
TimeSerialfunction,71,413
TintAndShadeproperty
Borderobject,677
Borderscollection,676
TintAndShadeproperty,Tabobject,904
titleattribute,303
Title button,186
Titleproperty
Add-In,639
AllowEditRangeobject,642
CustomTaskPaneobject,1016
FileDialogobject,1032
SharedWorkspaceTaskobject,1061
1135
Title property
I
n
d
e
x
106
TODAYfunction,73
<toggleButton .../>control type,299
ToggleFormsDesignmethod,Workbookobject,950
ToggleVerticalTextmethod,TextEffectFormat
object,907
toolbars,320–322,335–338
toolkit add-in,571
Tools menu,5
TooltipTextproperty
CommandBarButtonobject,1005
CommandBarComboBoxobject,1008
CommandBarControlobject,1012
CommandBarPopupobject,1015
Topproperty
Applicationobject,654
Axisobject,673
AxisTitleobject,675
ChartAreaobject,697
CommandBarobject,1002
CommandBarButtonobject,1005
CommandBarComboBoxobject,1008
CommandBarControlobject,1012
CommandBarPopupobject,1015
Rangeobject,857
Shapeobject,883
ShapeRangeobject,889
Windowobject,932,993
Top10object,915–917
TopBottomproperty,Top10object,916
TopLeftCellproperty,Shapeobject,884
TopLineproperty,CodePaneobject,978
ToReferenceStyle parameter,657
Trackingproperty,TextEffectFormatobject,907
TrackStatusproperty,RoutingSlipobject,870
Trainingmethod,355
TransitionExpEvalproperty,Worksheetobject,958
TransitionFormEntryproperty,Worksheetobject,958
TransitionMenuKeyproperty,Applicationobject,654
TransitionMenuKeyActionproperty,Application
object,654
TransitionNavigKeyproperty,Applicationobject,654
Transparencyproperty
GradientStopobject,1038
ShadowFormatobject,879
TrapApplicationevents procedure,365
TreeviewControlobject,917
Trendlineobject,917–919
Trendlinescollection,917–919
Trendlinesmethod,Seriesobject,876
TrimTextmethod,TextRange2object,1072
Trust Center dialog box,5,489,491
Trust Center settings,489,491,571
Trust Center user interface,491–503
ActiveX settings,495–496
Add-ins category,494
External Content category,499–500
macro settings,497–498
Message Bar,498–499
privacy options,501–503
trusted locations,492–493
trusted publishers,492
Trusted Locations category,492
Trusted Locations settings,496
TwoColorGradientmethod,ChartFillFormat
object,699
TwoInitialCapitalsproperty,AutoCorrectobject,666
type libraries,411,412,414,430
Typeparameter,68,670,690,693,841,917
Typeproperty
Actionobject,639
Axisobject,673
BulletFormat2object,997
CalculatedMemberobject,679
CalloutFormatobject,680
ChartColorFormatobject,698
ChartFillFormatobject,699
CommandBarobject,1002
CommandBarButtonobject,1005
CommandBarComboBoxobject,1008
CommandBarControlobject,1012
CommandBarPopupobject,1015
CustomXMLValidationError,1025
DocumentPropertyobject,1030
MetaPropertyobject,1045
Referenceobject,984
ReflectionFormat,1051,1067
SearchScope,1054
Seriesobject,875
ShadowFormatobject,879
Shapeobject,884
ShapeRangeobject,889
SmartTagActionobject,895
TabStop2object,1069
Top10object,916
Trendlineobject,918
UniqueValuesobject,920
Validationobject,923
VBcomponentobject,987
VBprojectobject,991
VPageBreakobject,925
Windowobject,932,993
Worksheetobject,958
TypeConditionTypeproperty,AboveAverage
object,637
1136
TODAY function
109
U
UBoundfunction,57,109,190
UDFs(user-definedfunctions),1,18–21,44,
333,373,384
creating,18–21
limitations,21
UFIcontrols,496
UINTCdata type,605
UINT FAR *Cdata type,605
UK settings,148,540
UnderlineColorproperty,Font2object,1037
UnderlineStyleproperty,Font2object,1037
Undomethod,Applicationobject,660
Ungroupmethod
Rangeobject,868
Shapeobject,885
ShapeRangeobject,891
Unhide button,6
Unionmethod,115,661
UniqueValuesobject,919–920
Unloadstatement,273,277,282
Unmergemethod,Rangeobject,868
Unprotectmethod
AllowEditRangeobject,642
Chartobject,694
Workbookobject,950
Worksheetobject,962
UnprotectSharingmethod,Workbookobject,950
Unsuspendmethod,Syncobject,1068
Untilstatement,52
unzipping Excel containers,266–267
UpBarsobject,920–921
Updatemethod
Add-inscollection,974
COMAddinscollection,997
UPDATEstatement,434–435,453
UpdateFromFilemethod,Workbookobject,950
UpdateLinkmethod,71,950
UpdateLinksproperty,Workbookobject,943
UpdateRemoteReferencesproperty,Workbook
object,943
Uriproperty,XMLNameSpace,969
URL encoding,535
URLproperty
SharedWorkspaceobject,1055
SharedWorkspaceFileobject,1056
SharedWorkspaceLinkobject,1059
U.S. settings,148,546,549,829
UsableHeightproperty
Applicationobject,654
Windowobject,932
UsableWidthproperty
Applicationobject,655
Windowobject,932
Use Advanced Filter,156,160
UseCommandObject procedure,459
UseDefaultFolderSuffixmethod,WebOptions
object,929
UsedObjectscollection,921–922
UsedObjectsproperty,Applicationobject,655
UsedRangeproperty,Worksheetobject,958
UseLegacyKeyboardShortcutsproperty,Application
object,655
UseLongFileNamesproperty,WebOptions
object,929
User key,396
User Table,844
User_Formresizeevent,630
USER32.EXEfile,602
UserAccessListcollection,922
UserAccessListobject,921
UserControlproperty,Applicationobject,655
User-defined (using Type)data type,43
user-definedfunctions (UDFs),1,18–21,44,
333,373,384
creating,18–21
limitations,21
User-defined menus,319
UserDictproperty,SpellingOptionscollection,900
UserFormcontrol,298,368
UserFormmodule,289
UserFormobject,26,273,277,406,594,597,622,
623,624,625,628,629,633
UserForm styles,622
UserForm text boxes,370
UserForm window,618
UserForm_Initializeevent,284,369,629,633
UserForm_Resizeevent,626,627,633
UserForms
creating,275–277
directly accessing controls,277–281
displaying,273–274
freezing,618
maintaining data lists,282–288
modeless,288–291
overview,594–598
resizable,625–634
absolute changes,626–627
CFormResizerclass,628–634
relative changes,627–628
showing as task panes,405–406
stopping Close button,281–282
1137
UserForms
I
n
d
e
x
Documents you may be interested
Documents you may be interested