vba學(xué)習(xí)初級(jí)入門(mén)到精通

1、目錄一、一、VBA語(yǔ)言基礎(chǔ)語(yǔ)言基礎(chǔ)..........................................................................................................................1第一節(jié)標(biāo)識(shí)符..........................................................................

2、...........................................................................1第二節(jié)運(yùn)算符..........................................................................................................................................

3、...........1第三節(jié)數(shù)據(jù)類(lèi)型.................................................................................................................................................1第四節(jié)變量與常量...............................................

4、..............................................................................................1第五節(jié)數(shù)組........................................................................................................................

5、.................................2第六節(jié)注釋和賦值語(yǔ)句.....................................................................................................................................2第七節(jié)書(shū)寫(xiě)規(guī)范...................................

6、..............................................................................................................2第八節(jié)判斷語(yǔ)句......................................................................................................

7、...........................................2第九節(jié)循環(huán)語(yǔ)句.................................................................................................................................................3第十節(jié)其他類(lèi)語(yǔ)句和錯(cuò)誤語(yǔ)句處理........

8、.........................................................................................................4第十一節(jié)過(guò)程和函數(shù).........................................................................................................

9、................................4一Sub過(guò)程...................................................................................................................................................4二Function函數(shù)......................

10、.....................................................................................................................5三Property屬性過(guò)程和Event事件過(guò)程...............................................................................

11、.....................5第十二節(jié)內(nèi)部函數(shù)..............................................................................................................................................5一測(cè)試函數(shù)..........................................

12、........................................................................................................5二數(shù)學(xué)函數(shù)..............................................................................................................

13、....................................5三字符串函數(shù)..............................................................................................................................................6四轉(zhuǎn)換函數(shù).............................

14、.....................................................................................................................6五時(shí)間函數(shù).................................................................................................

15、.................................................6第十三節(jié)文件操作.............................................................................................................................................6文件..................

16、................................................................................................................................................6刪除.........................................................................

17、.........................................................................................7打開(kāi)................................................................................................................................

18、..................................7讀入..................................................................................................................................................................7寫(xiě)入..................

19、................................................................................................................................................7關(guān)閉.........................................................................

20、.........................................................................................7其他文件函數(shù)............................................................................................................................

21、......................7二、二、VISUALBASIC程序設(shè)計(jì)網(wǎng)絡(luò)教學(xué)程序設(shè)計(jì)網(wǎng)絡(luò)教學(xué)......................................................................................1第一課第一課VBA是什么是什么................................................................

22、........................................................11.1VBA是什么...................................................................................................................................................11.2EXC

23、EL環(huán)境中基于應(yīng)用程序自動(dòng)化的優(yōu)點(diǎn)...............................................................................................11.3錄制簡(jiǎn)單的宏..................................................................................................

24、..............................................21.4執(zhí)行宏............................................................................................................................................................21.5查看錄制的代碼

25、............................................................................................................................................21.6編輯錄制的代碼.....................................................................

26、.......................................................................31.7錄制宏的局限性..........................................................................................................................................

27、..41.8小結(jié)................................................................................................................................................................4第二課第二課處理錄制的宏處理錄制的宏.................................

28、.....................................................................................42.1為宏指定快捷鍵............................................................................................................................

29、................42.2決定宏保存的位置........................................................................................................................................52.3個(gè)人宏工作簿..............................................

30、..................................................................................................52.3.1保存宏到個(gè)人宏工作簿..........................................................................................................

31、..............52.3.2使用并編輯個(gè)人宏工作簿中的宏........................................................................................................52.4將宏指定給按鈕.......................................................................

32、.....................................................................62.5將宏指定給圖片或其他對(duì)象........................................................................................................................62.6小結(jié).........

33、.......................................................................................................................................................713重新命名宏.............................................................

34、......................................................................................3414運(yùn)行宏的其它方法..........................................................................................................................

35、.............3415使用鍵盤(pán)快捷鍵運(yùn)行宏...............................................................................................................................3416通過(guò)菜單運(yùn)行宏.......................................................

36、....................................................................................3517通過(guò)工具欄按鈕運(yùn)行宏..........................................................................................................................

37、.....3718通過(guò)工作表里面的按鈕運(yùn)行宏...................................................................................................................3819保存宏............................................................................

38、...............................................................................3920打印宏......................................................................................................................................

39、.....................3921保存宏在個(gè)人宏工作簿...............................................................................................................................4022打開(kāi)含有宏的工作簿.............................................

40、......................................................................................4123VB編輯窗口............................................................................................................................

41、......................4224了解工程瀏覽窗口.......................................................................................................................................4325了解屬性窗口.........................................

42、......................................................................................................4326了解代碼窗口............................................................................................................

43、...................................4427VB編輯器里的其它窗口.............................................................................................................................4628接下來(lái)……....................................

44、...............................................................................................................46第二章第二章VBA第一步第一步............................................................................................

45、.........................461了解指令，模塊和過(guò)程.................................................................................................................................472VBA工程命名...........................................

46、.....................................................................................................473模塊重命名...............................................................................................................

47、......................................484從其它工程調(diào)用過(guò)程.....................................................................................................................................495了解對(duì)象，屬性和方法........................

48、.........................................................................................................506學(xué)習(xí)對(duì)象，屬性和方法......................................................................................................

49、...........................517句法和文法.....................................................................................................................................................538打斷很長(zhǎng)的VBA語(yǔ)句.......................

50、............................................................................................................559了解VBA錯(cuò)誤......................................................................................................

51、.........................................5510查找?guī)椭?......................................................................................................................................................5711語(yǔ)法和編程快捷助手.......

52、............................................................................................................................5812屬性方法列表......................................................................................

53、........................................................5913常數(shù)列表.......................................................................................................................................................5914參

54、數(shù)信息.......................................................................................................................................................6015快速信息..........................................................

55、.............................................................................................6016自動(dòng)完成關(guān)鍵字....................................................................................................................

56、.......................6017縮進(jìn)凸出......................................................................................................................................................6118設(shè)置注釋塊解除注釋塊.........................

57、.....................................................................................................6119使用對(duì)象瀏覽器............................................................................................................

58、...............................6120使用VBA對(duì)象庫(kù).........................................................................................................................................6621用對(duì)象瀏覽器來(lái)定位過(guò)程.........................

59、..................................................................................................6722使用立即窗口................................................................................................................

60、...............................6723獲取立即窗口里的信息...............................................................................................................................6924學(xué)習(xí)對(duì)象........................................

61、...............................................................................................................7025電子表格單元格操作................................................................................................

62、...................................7026使用RANGE屬性..........................................................................................................................................7027使用CELLS屬性.....................

63、......................................................................................................................7128使用OFFSET屬性........................................................................................

64、.................................................7129選擇單元格的其它方法...............................................................................................................................7230選擇行和列.....................

65、..............................................................................................................................7331獲取工作表信息...................................................................................

66、........................................................7332往工作表輸入數(shù)據(jù).......................................................................................................................................7333返回工作表中的信息....