不好意思，我貼個(gè)目錄

第1 章 VBA 入門................................................................................1
1.1 概述..........................................................................................2
1.2 通過(guò)宏來(lái)認(rèn)識(shí)VBA.................................................................2
1.2.1 錄制宏..............................................................................3
1.2.2 運(yùn)行宏..............................................................................8
1.3 第一個(gè)VBA 程序....................................................................9
1.4 常量和變量............................................................................12
1.4.1 常量................................................................................12
1.4.2 變量................................................................................13
1.5 VBA 中的數(shù)據(jù)類型...............................................................14
1.5.1 Boolean 數(shù)據(jù)類型..........................................................14
1.5.2 Byte 數(shù)據(jù)類型...............................................................15
1.5.3 Currency 數(shù)據(jù)類型........................................................15
1.5.4 Data 數(shù)據(jù)類型...............................................................15
1.5.5 Decimal 數(shù)據(jù)類型..........................................................15
1.5.6 Double 數(shù)據(jù)類型...........................................................16
1.5.7 Integer 數(shù)據(jù)類型............................................................16
1.5.8 Long 數(shù)據(jù)類型...............................................................16
1.5.9 Object 數(shù)據(jù)類型............................................................16
1.5.10 Single 數(shù)據(jù)類型...........................................................16
1.5.11 String 數(shù)據(jù)類型...........................................................17
1.5.12 用戶自定義數(shù)據(jù)類型..................................................17
1.5.13 Variant 數(shù)據(jù)類型.........................................................17
1.6 數(shù)組........................................................................................17
1.6.1 靜態(tài)數(shù)組........................................................................18
1.6.2 動(dòng)態(tài)數(shù)組........................................................................
1.6.3 數(shù)組的基本操作............................................................20
1.7 運(yùn)算符....................................................................................20
1.7.1 算術(shù)運(yùn)算符....................................................................21
1.7.2 比較運(yùn)算符....................................................................22
1.7.3 連接運(yùn)算符....................................................................23
1.8 分支語(yǔ)句................................................................................23
1.8.1 Select Case 語(yǔ)句............................................................23
1.8.2 With 語(yǔ)句.......................................................................26
1.9 判斷語(yǔ)句................................................................................28
1.10 循環(huán)語(yǔ)句..............................................................................30
1.10.1 Do…Loop 語(yǔ)句............................................................30
1.10.2 For…Next 語(yǔ)句............................................................31
1.10.3 For Each…Next 語(yǔ)句...................................................33
1.10.4 While…Wend 語(yǔ)句......................................................34
1.11 過(guò)程和函數(shù)..........................................................................34
1.11.1 Function 過(guò)程...............................................................35
1.11.2 Sub 過(guò)程.......................................................................37
1.11.3 參數(shù)傳遞......................................................................38
第2 章 對(duì)象速查.............................................................................44
A......................................................................................................45
AddIn .........................................................................................45
Adjustments................................................................................46
Application.................................................................................46
Assistant .....................................................................................47
AutoCorrect................................................................................47
AutoFilter ...................................................................................47
C ......................................................................................................48
Cells ...........................................................................................48
Chart...........................................................................................