"
""
"""
&
(
)
).
,
.
:=
].
^
<
<=
<>
=
>
>=
1
2
3
4
5
6
7
8
9
Activate
Active
ActiveCell ActiveSheet ActiveWindow ActiveWorkbook
Add
Address
AddShape AddShape(
After
AlertStyle AllowDeletingColumns AllowDeletingRows AllowEdit AllowEditRanges AllowFiltering AllowUsingPivotTables And
Application
Areas(
Array(
As
Asc(
Atn(
Attribute
AutoFill
AutoFit AutoFormat AutoLength AutoLoad BackColor Background BarShape
Before BeforeDoubleClick BeforeRightClick Binary BlackAndWhite BlackWhiteMode Bold
Boolean
Border
Borders BottomMargin ByVal
Calculate Calculate( Calculation
Call CallByName Caption
Case
Cdate
Cells
Cells( CenterHeader CenterHeaderPicture CenterHorizontally CenterVertically ChangeFileAccess Characters CharacterType Chart
Charts
Charts( ChartSize ChartTitle
CheckBox CheckboxState Choices
Chr(
Class
Clear ClearContents
Click
Click(
Close
Color
ColorIndex
Colors
ColorType Column ColumnFields ColumnItems ColumnRange Columns
Columns( Columns.Count ColumnWidth ColumnWidth ComboBox CommandBars CommandButton CommandText CommandType Comment Comments Connection ConnectionSiteCount Container Contents
Copy
Count CreateObject CreateObject( CropBottom CropLeft CropRight CropTop
CStr( Currentregion Cursor CutCopyMode DataOption DataSeries
Deactivate(
Debug
Default DefaultFilePath DefaultSaveFormat DefaultSheetDirection DefaultValue
Delete
Dependents
Depth
DepthPercent Destination
Dialogs
Dictionary
Dim
Dir
Dir(
Disable
DisplayAlerts DisplayClipboardWindow DisplayEmptyColumn DisplayEmptyRow DisplayFormulaBar DisplayFormulas DisplayFullScreen DisplayFunctionToolTips DisplayGridlines DisplayHeadings DisplayHorizontalScrollBar DisplayImmediateItems DisplayNullString DisplayOutline DisplayScrollBars DisplayStatusBar DisplayUnit DisplayUnitCustom DisplayUnitLabel DisplayVerticalScrollBar DisplayWorkbookTabs DisplayZeros
Do
Doevents
Double
DoubleClick
DragOver
DragPlot DragToColumn
DropDownLines Each
Else
ElseIf
Enable EnableAutoFilter Enabled EnableEditing EnableEvents EnableItemSelection EnableOutlining EnableRefresh EnableResize EnableSelection EnableSound EnableWizard
End Function
End If
End Select
End Sub
End With
End( Entirecolumn Entirerow
Error
Errors
Exists
Exists(
Exit
Exit For
Exit Sub
False
FileCopy FileFormat Filename
Fill FillAdjacentFormulas FillDown FilterMode
Filters
Find( FindControls FitToPagesTall FitToPagesWide Folder
Font
FontBold
FontSize
FontStyle FooterMargin
For
ForeColor FormatConditions Formula
Formula1
Formula2 FormulaArray FormulaHidden FormulaLabel FormulaR1C1 FullName FullNameURLEncoded Function
GetFolder( GetObject( GetOpenFileName GetOpenFilename( GotFocus
Goto
Header
Height
Hidden
Hyperlink Hyperlinks
ID
If
Ignore
IgnoreBlank IgnoreCaps IgnoreFileNames
IIf
IIf(
IMEMode
In
Index
Initialize
Initialize(
InputBox
InputBox(
Insert( InsertRowRange InsideHeight InsideLeft
InStr(
InStrRev(
Int(
Integer
Interior International Intersect(
Is
IsEmpty(
IsError( IsMemberProperty( IsPercent(
IsValid(
Italic
Item
Join( KeepChangeHistory Key
Key1
Keys
Kill
Label LanguageSettings Layout LayoutBlankLine LBound
Lbound( LeaderLines
Left
Left(
LeftFooter LeftFooterPicture LeftHeader LeftHeaderPicture LeftMargin Legend
Len(
Length
Like
Line
LineStyle LinkedCell LinkFormat Listbox LoadPictures Location
LookAt
Loop
LostFocus
MarginBottom
MarginLeft
MarginRight
MarginTop MarkerBackgroundColor MarkerBackgroundColorIndex MarkerForegroundColor MarkerForegroundColorIndex MarkerSize
MarkerStyle
MatchCase
Max
Max(
Me
MergeArea
MergeCells
Message
Mid(
Min(
MouseAvailable MouseDown
MouseMove
MouseUp
Move
Msgbox
Msgbox( msoShapeRectangle MultiSelect
Name
Names
Names(
New
NewWorkbook
Next
Not
Nothing
Now
NullString
Number
NumberAsText NumberFormat
Object
Offset(
OffsetY
On
Open
OpenText
OpenXML
Option Compare Text
Option Explicit
Optional
Optionbutton
Or
Order
Orientation
Origin
PaperSize
Parameters
Parent
Password
Paste
PasteSpecial
Path
Pattern
Permission
PictureFormat
Pictures
PictureType
PictureUnit
PivotTableCloseConnection
PivotTableOpenConnection
PivotTableUpdate
Placement
Points
Position
Preserve
PrintArea
PrintSettings
Private
Private Sub QueryTable_AfterRefresh(Success As Boolean)
Private Sub QueryTable_BeforeRefresh(Cancel As Boolean)
Private Sub Workbook_AddinInstall()
Private Sub Workbook_AddinUninstall()
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Private Sub Workbook_BeforeSave(ByVal SaveAsUi As Boolean, Cancel A Private Sub Workbook_NewSheet(ByVal Sh As Object)
Private Sub Workbook_Open()
Private Sub Worksheet_Activate()
Private Sub Worksheet_Change(Byval Target As Range)
Private Sub Worksheet_SelectionChange(Byval Target As Range) Prompt
Protect
Protection
ProtectionMode
Public
Put
Quit
Range
Range(
RangeSelection
ReadOnly
ReDim
regWrite
Replace
Replace(
Replacement
Resize(
Resume
Right
Right(
Rotation
Row
Row(
Rowcol
RowHeight
Rows
Rows(
Rows.Count
Save
SaveCopyAs
Saved
Scenarios
ScreenSize
ScreenTip
ScreenTip
ScreenUpdating
Script
Scripts
ScrollArea
ScrollColumn
ScrollRow
Select
Select Case
SelectedSheets
Selection
SelectionMode
SeriesChange
Shape
Shapes
Shapes(
Sheet
SheetActivate SheetBeforeDoubleClick SheetBeforeRightClick SheetCalculate SheetChange SheetDeactivate SheetFollowHyperlink SheetPivotTableUpdate Sheets
Sheets( SheetSelectionChange Shell
Shell(
Shift
ShowAllItems ShowAutoFilter
Size
Sort
SortFields SortMethod
SortOn
Source
SourceData SourceDataFile SourceName SourceRange SourceType SpecialCells SpecialCells(
Speech
Split(
SplitColumn SplitHorizontal SplitRow
SplitType
SplitValue SplitVertical StandardFont StandardFontSize StandardFormula StandardHeight StandardWidth
Start
Step
String
StrReverse
Style
Styles
Sub
SubAddress SubFolder
Subject SubtotalName Subtotals
Sync
Tab
Text
Textbox TextToDisplay
Then ThisWorkbook ThisWorkbook.Sheets( Time
TimeValue
Title
To
Top
TopLeftCell TopMargin Transpose(
Trim(
True
Type
Type
Ubound(
Unload
Unprotect
Until
UsedRange UserForm UserInterfaceOnly UserPicture
Val(
Value
Value2
Values
vbBack
vbBlack
vbBlue
vbNewLine
vbPink
vbRed
vbTab
vbWhite
vbYellow
Version
Visible
VisibleFields
VisibleItems
VisibleRange
What
While
Width
WindowActivate WindowDeactivate WindowResize
Windows(
With
With ActiveSheet
Workbook
WorkbookActivate WorkbookAddinInstall WorkbookAddinUninstall WorkbookBeforeClose WorkbookBeforePrint WorkbookBeforeSave WorkbookBeforeXmlExport WorkbookBeforeXmlImport WorkbookDeactivate WorkbookNewSheet WorkbookOpen WorkbookPivotTableCloseConnection WorkbookPivotTableOpenConnection Workbooks
Workbooks(
WorkbookSync
Worksheet
WorksheetFunction
Worksheets
Worksheets(
xlAscending xlCellTypeConstants
xlDown
xlFillSeries
xlGuess
xlPinYin xlReadOnly xlSortNormal xlSortOnValues xlToLeft xlTopToBottom xlToRight
xlUp
xlValues
xlWhole xlWindows
xlYes
Get
Global IgnoreCase Execute(
Match
RegExp MatchCollection xlFilterCopy CriteriaRange CopyToRange Unique AdvancedFilter Action
Class
Initialize(
Declare SetTimer
Lib
KillTimer
Timer
Alias SetFocusAPI CreateWindowEx CreateFont DestroyWindow SendMessage ShowWindow Erase CreateObject(
Abs(
Small( ColumnDifferences( xlFormulas SearchDirection
SearchFormat
TextEffect
AppEvents
LTrim(
RTrim(
Variant
Filter(
VBProject
VBComponents
vbext_ct_StdModule
Add(
vbext_ct_ClassModule
vbext_ct_MSForm
Remove
VBComponents( VBComponent
CodeModule
AddFromString
InsertLines
CountOfLines CountOfDeclarationLines
Lines(
ProcBodyLine(
ProcStartLine( ProcCountLines( CreateEventProc(
DeleteLines
ReplaceLine
AddFromFile
References(
References
FullPath
SendKeys
vbext_pp_locked CommandBars(
Execute
Controls(
vbext_pp_none
Controls
Application.ScreenUpdating = False Application.ScreenUpdating = True Application.DisplayAlerts = False Application.DisplayAlerts = True Application.EnableEvents = False Application.EnableEvents = True Rnd(
LineWidth
Borders(
Format( Datevalue( Insert Rnd Evaluate( Case Else
"
空值
""
&
(
)
的
,
的
=
的
乘方次数
小于
小于或等于 不等于
等于
大于
大于或等于 0
1
2
3
4
5
6
7
8
9
激活
活动
活动单元格活动工作表活动窗口
活动工作簿添加
地址
添加图形
添加图形(
后面于
警告类型
允许删除列允许删除行允许编辑
允许编辑区域允许筛选
允许数据透视 并且
应用程序
<数组>(
为
<字符转数值>(
<反正切值>(
属性
自动填充
自动调整
自动套用格式
自动长度
自动加载
背景色
背景
条形状
前面于
鼠标双击前
鼠标右击前
二进制
黑白
黑白模式
粗体
布尔值
边框
边框
下边距
变量
重新计算
<重画或重新计算后>(重新计算
调用
通过名称调用函数 标题
条件情况
字符串转日期
单元格集合
<单元格>坐标(
页眉
页眉图片
水平居中
垂直居中
更改文件访问
字符集
字符类型
图表
图表集
图表
图表尺寸
图表标题
复选框状态
选择
<数值转字符>(类
清除
清除内容
点击
<点击>(
关闭
颜色
颜色索引值
颜色
颜色类型
列标
列域
列项目
列范围
列标
<列>坐标(
列数值
列宽
列宽
组合框
命令条
命令按钮
命令文本
命令类型
批注
批注集
连接
连接点计数
容器
内容
复制
计数值
创建对象
<创建工程>(
修剪底部
修剪左侧
修剪右侧
修剪顶部
<转换为字符串>(当前区域
光标
剪切拷贝模式
数据选项
数据序列
<转为非活动状态>(
调试方式
默认值
默认文件路径
默认保存格式
默认工作表目录
默认值
删除
来源
深度
深度百分比
目标位置
对话
字典
定义变量
下一个文件
<查找文件或目录>(
禁用
显示警告信息
显示剪贴板窗口
显示空列
显示空行
显示公式栏
显示公式
全屏显示
显示函数工具提示
显示风格
显示标题
显示水平滚动条
显示即时项目
显示空字符串
显示轮廓
显示滚动条
显示状态栏
显示单位
显示定制单位
显示单位标签
显示垂直滚动条
显示工作簿制表符
显示零值
执行循环操作
转让系统控制权
双精度值
双击
单元格区域拖过图表时单元格区域拖放到图表上拖至列