《Excel VBA 语法字典》附书源码

《Excel VBA 语法字典》附书源码 已重新整理，每个Excel文件名均有主题词，如“2_040_1_PivotFields.xls”文件表示第二章第40条关于“PivotFields”的示例文 件，重新按图索骥，进行阅读。 全书目录 Chapter 1 Excel VBA的基本操作 1-1 打开Visual Basic编辑器 1-2 建立新的模块 1-3 执行Visual Basic宏 Chapter 2 集合 2-1 Addlns 2-2 AIIowEditRanges 2-3 Areas 2-4 Areas 2-5 Axes 2-6 Borders 2-7 Borders 2-8 CalculatedFields 2-9 Calculatedltems 2-10 ChartGroups 2-11 Char[Objects 2-12 Charts 2-13 Comments 2-14 Comments 2-15 CustomProperties 2-16 CustomViews 2-17 CustomViews 2-18 DataLabels 2-19 DataLabels 2-20 Diagr amNodes 2-21 Dialogs 2-22 FormatConditions 2-23 HPageBreaks 2-24 Hypedinks 2-25 Hyperlinks 2-26 Hyperlinks 2-27 LegendEntries 2-28 ListColumns 2-29 ListColumns 2-30 ListObjects 2-31 ListObjects 2-32 ListRows 2-33 ListRows 2-34 Names 2-35 OLEObjects 2-36 OLEObjects 2-37 Panes 2-38 Parameters 2-39 PivotCaches 2-40 PivotFields 2-41 PivotFields 2-42 Pivotltems 2-43 PivotTables 2-44 PivotTables 2-45 Points 2-46 Points 2-47 PublishObjects 2-48 QueryTables 2-49 Range 2-50 Range 2-51 Range 2-52 Range 2-53 Range 2-54 RecentFiles 2-55 Scenarios 2-56 Scenarios 2-57 SeriesCollection 2-58 SeriesCollection 2-59 ShapeNodes 2-60 SbapeRange 2-61 Shapes 2-62 Shapes 2-63 Sheets 2-64 Sheets 2-65 Styles 2-66 Styles 2-67 Trendlines 2-68 Trendlines 2-69 UsedObjects 2-70 UserAccessList 2-71 VPageBreaks 2-72 Watches 2-73 Watches 2-74 Windows 2-75 Windows 2-76 Workbooks 2-77 Worksheets 2-78 Worksheets Chapter 3 对象 3-1 Addln 3-2 Addln 3-3 Adjustments 3-4 Adjustments 3-5 AIIowEditRange 3-6 Application 3-7 Application 3-8 Application 3-9 AutoCorrect 3-10 AutoCorrect 3-11 AutoFilter 3-12 AutoRecover 3-13 Axis 3-14 Axis 3-15 AxisTitle 3-16 Border 3-17 CalloutFormat 3-18 Characters 3-19 Chart 3-20 Chart 3-21 ChartArea 3-22 ChartGroup 3-23 ChartObject 3-24 ChartTitle 3-25 ColorFormat 3-26 Comment 3-27 ConnectorFormat 3-28 CustomView 3-29 DataLabel 3-30 Diagram 3-31 DiagramNode 3-32 DiagramNodeChildren 3-33 Dialog 3-34 OisplayUnitLabel 3-35 ErrorBars 3-36 ErrorCheckingOi 3-37 FilIFormat 3-38 Filter 3-39 Floor 3-40 Font 3-41 FormatCondition 3-42 Gridlines 3-43 HPageBreak 3-44 Hyperlink 3-45 Interior 3-46 Legend 3-47 LegendEntry 3-48 LegendKey 3-49 LineFormat 3-50 LinkFormat 3-51 ListColumn 3-52 ListObject 3-53 ListRow 3-54 Name 3-55 OLEObject 3-56 Outline 3-57 PageSetup 3-58 Pane 3-59 Parameter 3-60 Phonetic 3-61 PictureFormat 3-62 PivotCache 3-63 PivotField 3-64 PivotField 3-65 Pivotltem 3-66 PivotTable 3-67 PivotTable 3-68 PlotArea 3-69 Point 3-70 Protection 3-71 PublishObject 3-72 QueryTable 3-73 QueryTable 3-74 RecentFile 3-75 RoutingSlip 3-76 Scenario 3-77 Series 3-78 Series 3-79 SeriesLines 3-80 ShadowFormat 3-81 Shape 3-82 Shape 3-83 ShapeNode 3-84 SpellingOptions 3-85 Style 3-86 Tab 3-87 TextEffectFormat 3-88 TextFrame 3-89 ThreeDFormat 3-90 TickLabels 3-91 Trendline 3-92 Validation 3-93 VPageBreak 3-94 Walls 3-95 Watch 3-96 Window 3-97 Window 3-98 Workbook 3-99 Workbook 3-100 Workbook 3-101 Worksheet 3-102 Worksheet 3-103 WorksheetFunction Chapter 4 方法 4-1 Activate 4-2 ActivateMicrosoftApp 4-3 ActivateNext 4-4 ActivatePrevious 4-5 Add 4-6 AddCallout 4-7 AddChadAutoFormat 4-8 AddComment 4-9 AddConnector 4-10 AddCustomList 4-11 AddDataField 4-12 AddFormControl 4-13 Addltem 4-14 AddLabel 4-15 AddLine 4-16 AddNode 4-17 AddNodes 4-18 AddOLEObject 4-19 AddPicture 4-20 AddReplacement 4-21 AddShape 4-22 AddShape 4-23 AddTextbox 4-24 AddTextEffect 4-25 AddToFavorites 4-26 Align 4-27 Apply 4-28 ApplyCustomType 4-29 ApplyCustomType 4-30 ApplyDataLabels 4-31 Arrange 4-32 AutoFill 4-33 AutoFilter 4-34 AutoFit 4-35 AutoFormat 4-36 AutoFormat 4-37 Axes 4-38 BeginConnect 4-39 BeginDisconnect 4-40 BorderAround 4-41 BringToFront 4-42 BuildFreeform 4-43 CentimetersToPoints 4-44 ChangeFileAccess 4-45 Characters 4-46 ChartObjects 4-47 CheckSpelling 4-48 Clear 4-49 ClearComments 4-50 ClearFormats 4-51 ClearNotes 4-52 Close 4-53 ColumnDifferences 4-54 ColumnGroups 4-55 ConvertToShape 4-56 Copy 4-57 CopyPicture 4-58 CreateNames 4-59 CustomDrop 4-60 CustomLength 4-61 Cut 4-62 DataSeries 4-63 Delete 4-64 DeleteAII 4-65 DeleteChartAutoFormat 4-66 Deselect 4-67 Dirty 4-68 Distribute 4-69 DoubleClick 4-70 EndConnect 4-71 EndDisconnect 4-72 EndReview 4-73 Export 4-74 Extend 4-75 FillAcrossSheets 4-76 FillDown 4-77 FillLeft 4-78 FillRight 4-79 FilIUp 4-80 Find 4-81 FindFile 4-82 FindNext 4-83 FindPrevious 4-84 Flip 4-85 Format 4-86 FunctionWizard 4-87 GetOpenFilename 4-88 GetData 4-89 GetSaveAsFilename 4-90 GoalSeek 4-91 Goto 4-92 Group 4-93 Help 4-94 InchesToPoints 4-95 IncrementBrightnes 4-96 IncrementContrast 4-97 IncrementLeft 4-98 IncrementOffsetX 4-99 IncrementOffsetY 4-100 IncrementRotation 4-101 IncrementRotationX 4-102 IncrementRotationY 4-103 IncrementTop 4-104 InputBox 4-105 Insert 4-106 Item 4-107 Justify 4-108 LargeScroll 4-109 LegendEntries 4-110 ListNames 4-111 Location 4-112 Move 4-113 NewWindow 4-114 NoteText 4-115 OneColorGradie 4-116 OnKey 4-117 Open 4-118 OpenText 4-119 Parse 4-120 Paste 4-121 PasteSpecial 4-122 Patterned 4-123 PickUp 4-124 PresetDroD 4-125 PresetGradient 4-126 PresetTextured 4-127 PrintOut 4-128 PrintPreview 4-129 Protect 4-130 Quit 4-131 RemoveSubtotal 4-132 Repeat 4-133 Replace 4-134 ResetAIIPageBreaks 4-135 Save 4-136 ScaleHeight 4-137 ScaleWidth 4-138 ScrolllntoView 4-139 ScrollWorkbookTabs 4-140 Select 4-141 SelectAII 4-142 SeriesCollection 4-143 SetBackgroundPicture 4-144 Show 4-145 ShowAIIData 4-146 SmallScroll 4-147 Solid 4-148 Text 4-149 Undo 4-150 Ungroup 4-151 WebPagePreview