excel VBA速查宝典，方便使用

非常掌上宝YExcel VBA速查
宝典
北京希望电子出版社 总策划
非常掌上宝编委会 编 写


目 录
第 1 章 VBA 入门................................................................................1
1.1 概述..........................................................................................2
1.2 通过宏来认识VBA .................................................................2
1.2.1 录制宏..............................................................................3
1.2.2 运行宏..............................................................................8
1.3 第一个VBA程序....................................................................9
1.4 常量和变量............................................................................12
1.4.1 常量................................................................................12
1.4.2 变量................................................................................13
1.5 VBA中的数据类型...............................................................14
1.5.1 Boolean数据类型..........................................................14
1.5.2 Byte数据类型...............................................................15
1.5.3 Currency 数据类型........................................................15
1.5.4 Data数据类型...............................................................15
1.5.5 Decimal数据类型..........................................................15
1.5.6 Double数据类型...........................................................16
1.5.7 Integer数据类型............................................................16
1.5.8 Long数据类型...............................................................16
1.5.9 Object数据类型............................................................16
1.5.10 Single数据类型...........................................................16
1.5.11 String数据类型...........................................................17
1.5.12 用户自定义数据类型..................................................17
1.5.13 Variant数据类型.........................................................17
1.6 数组........................................................................................17
1.6.1 静态数组........................................................................18
1.6.2 动态数组........................................................................19

1.6.3 数组的基本操作............................................................20
1.7 运算符....................................................................................20
1.7.1 算术运算符....................................................................21
1.7.2 比较运算符....................................................................22
1.7.3 连接运算符....................................................................23
1.8 分支语句................................................................................23
1.8.1 Select Case语句............................................................23
1.8.2 With语句.......................................................................26
1.9 判断语句................................................................................28
1.10 循环语句..............................................................................30
1.10.1 Do…Loop语句............................................................30
1.10.2 For…Next语句............................................................31
1.10.3 For Each…Next语句...................................................33
1.10.4 While…Wend语句......................................................34
1.11 过程和函数..........................................................................34
1.11.1 Function过程...............................................................35
1.11.2 Sub过程.......................................................................37
1.11.3 参数传递......................................................................38
第 2 章 对象速查.............................................................................44
A ......................................................................................................45
AddIn .........................................................................................45
Adjustments................................................................................46
Application.................................................................................46
Assistant .....................................................................................47
AutoCorrect................................................................................47
AutoFilter ...................................................................................47
C ......................................................................................................48
Cells ...........................................................................................48
Chart...........................................................................................48