/目錄一、ＶBＡ語言基礎．．.．..．.。．.。．．。．。。。．.．．．。.．.。。．．.．。．.。。.。。。．.．。。．．。.．。。.．。.。。。。..。.。。..。。.。。。.。．.。。．。．．．.。..。。..。.．。。.。.．．。。..。。．。.1第一節(jié)標識符..．。.．.。．.．．.。。。。..。.．．。...。。。．。。。。。．.．.．．.．．．。。。.．．．。．。．．。...。.。.。.。。.．．.．.．。。．。.。.。。。.。。..．．..。．．．．。。.．。。．。。．。。．．.．．。.．．.．．.。．１第二節(jié)運算符..。.。．。.．。.．。.．．..。．..。.。。．。．．。。．.。．。..。.．．。.．．..．.．。。.。。．．.．。。。。．．..。。。。．．.．。．．。..。．..。..。.．。.．。．.．．.。。.。。．．．．．..。．．...．。..．.。。.。。。1第三節(jié)數據類型..。.．．..。.．..。。。。。。..。.。。。.。.。。。．。。。。.。．。。.。。...。.。.。.。．．..。.。．.。...。。．..。.。．．．．。。。..。。。。．..．.．.。。。.．。。。。．．．。．。．.。。．．...。...。。．.1第四節(jié)變量與常量..．．.。.。.。。。。..．..。.．．..。。．.．．。．..。.。。。...．..。．。。。。.．。.．。..。..．。..。．。．。。..。。.。.。.。...．．。．．。...．．.。.．.．．..。。。。．．。．.．．.．．。．。.。1第五節(jié)數組。．..．.。。.。..。.。。。.。。。．。。．。。...。。...．.。。。..．。..．.．。．...．。。。。..。．。．．.。.。.。。．．.．..。．。．。．。．。..．。。.．.．．。。。。。。...。．。．。.。。．。。．..。.。。..。.。．...。．2第六節(jié)注釋和賦值語句。。.。．。．。．．．..。。。...．。。．．。。。.。。．.．。．。．...．.。。。．。．.．．。．.。。。。..．.．。．。。．。。．.．.。.．。。..。。。。。。.。。．.。。..。．。。。。。。..．．..．.2第七節(jié)書寫規(guī)范．。．．。.。．...。...。。。。．.。。。．..．。.。.。.。..。。。．．.。.。。.。。。。..。。．.．.。..。．。。.。。..．。..。..。．．.．．。。..。.．..．.。。。.．．．.．．。．。．．．...2第八節(jié)判斷語句。.。.．。．...。.．．．。．。。。。．.。．.。。..．．.．.。。.。.。...。。.。．。。．．。。．.。。..．．。.．.。..。.．．.．．。．．．．..。..。。.。.。．。。．．。.。。。。。.。。２第九節(jié)循環(huán)語句。。．..．.．。．。．．.。．。．.。．.．．。.．。．...．.。.．.。。．。．。。．．。。.。.。．。.．.．.。。。。．．.。.。。。。.。。。。。。．.．。。。。.。．。．.．..．。.。．。．．.。。.。。．．。。.。．.．．。。.。．。。。3第十節(jié)其他類語句和錯誤語句處理.。．.．.．.。．。。。.．．．.。..。..。..。。。...。。..。..。。...．。。。..．。.。。..。。.。。。．..．..。。..。.．.。。..。.．.．。.。。4第十一節(jié)過程和函數．．。。.．.。..．。。...．.．.．.。．。。.．。．．。。。。..。.。．..．。.。.．.．．.。。.．。.。.．．。.。.。．..．。。.．．.．．。。。．。..．...。.．。.。．.。．.。．．。。．。。4一．Sub過程。．。．.．．。.．．．。．.。。。.。.。.．．。．.．。。．.．．.。..．．。。。.．。。.。．。．。。。。..。.4二。Fｕｎctioｎ函數..．。..。。．．。。.．。。..．.．.．.．..。．..。．。。。.．．...。．。。。．。。.。.。。。.。。.５三．Proｐerty屬性過程和Ｅvent事件過程.。．。..。.。．。.。.。．.。.。..．.。．.。.．..．.．.。．．..5第十二節(jié)內部函數.．。.．．．.。.．.。．。。。..。．。。．.．。。。．．．。。．.。．。。。。．.。。．.．。.。..．...。。。。．...。．。。.．。...．．．．．。。.。.。.．.。．。．。。...。．．。．..。。．。.。．。.．。．．.。。.。.5一．測試函數．．。。．．。．..．.。。。。.．..．。。。。..。.．．.．。.．.．.．.。...。．。..。..．.。。．．..。．．5二.數學函數.。。.。。.．.．.．。。．．.。.．。.。．。.．.．．．。。..。。。．．。。.。．．。．。.。.．．．。．．。。5三.字符串函數。。.．.。．。。。.。．．．．．．．.．.。。．．。.。.。。.．.．。。。．.．.。．。.。。.。。．。。。.。.．。.５四.轉換函數..．．...。。。。。。。。.。。。.。...。．。．..。。.。。。。。．.。。．.。。．．。．。。．。．．．...．．。。6五．時間函數．.。..．．..．.。。。.。.。..。．.。。。。.。。。。。.。..。．.。。。。。..。.。．.。．．。。．.．..．．6第十三節(jié)文件操作．.．。。.．。。。．。..。。.。.．．.。。..．．。。．。.．．..．。。。．．。。．．．．。..。。。．．．.．．。．．.。.．。..．。．..．.。.。.．．.．.．。．。..。.。。．...．．。．..。...．..．。6文件.。．。。。.．..。.。。．.。.。。．．．。.．.。。..。.．．.．...。.．．。．。．...。。..．。.．．..．。。．６刪除．..。。.。．．。。。。。。．。...．.。.。．．.。。..。.。．..。．。．．。。．。.．...．．。.。。.．。..6打開．...。.。..。．。..。。．。。。。.．．.。.。...。.。.．。．。。.．..。。.。。。。．.。。．．..。．。。。.．。6讀入。.。..。.。．．．。。。。．．。。．．。。。.．。。.。.．.。．。。．。。．.．..．．．..。.．。。.．。。．.。。．。。..．．。.７寫入..．.．..。．。。。.。．。．。．。．。.。。．。.。．．．．。．。。。。。.．.。。.。。.．。..。.．..。．．.。..。。。７關閉。..。．．...。。．.。．.．..．．。．。。。...．。.。．．。。.。.。．．。.。.。。．．.．。..．．．．。．.．．．。。.。..7其他文件函數．..。.。．.．。.。.。．..。。.．。．。..．.。.。。..．。．..．。．。。。。。。．．．.．。。。．．。.7二、VISＵALBASIC程序設計網絡教學。。。.．。。.。。.．.。。。。．.．.。。.。．.。.。.．.．。。。．．。。。.。。。。。．。。。．.。。。。．。..．．。.。．．..。。..。。.。。.１第一課VＢＡ是什么..。.．.。..．.。．．．。．.．．.。。.。。.。.．．．。。。。.。.．．。...。。.。。．。..。。。。．.。..。．．.．。。.。..。．。。.．..。。。。...。。．。.。。...。。。。..11.１VBA是什么．。。..。．.。。．。。...。.。．.。。...．．。.．.．...．。。。．。。．.。..。.。..．。.。。。．．．．..．。。。．..。.。。.。.。．。.。。..。。...．．。。.。.．。.。．。．..。。．．.。...．。。．。．．。..。．...11。2ＥＸCEL環(huán)境中基于應用程序自動化的優(yōu)點。。.。。.。..。。.．．.。。。.。。．。。..．。．。。.。..．。。.。．．.．。．.．..．。．。...．。。.。。。。。１1.3錄制簡單的宏．..。。.．。。。.．。．。。.。．..。.．.．。.。。．．...。。。..。。.。。．..。。。。.．。．．．．。。.．。.。.．..．。。。。.．．.。．.．.．。．．．。．．.。。.。．．．。．。．．。．.。..。..1１。4執(zhí)行宏。．。．...．。．。．.．。．。。。。。．.．．。．..。。．..。．。。。.．．.。．.。．..。..．.。．.。．。．。..。．...．．.．..．．。.。。。．.。。.。．．.．。.。．.。．.。．。。.．．．。。.。。.。．..。.21．5查看錄制的代碼．。。..。。.。．.．.。.．．。.。.。．．．。。．。。．。.。。.．。．．.．．.。.。。．．.。。。．。。．。...．。。．.。。.．．．.。。...。．.．。...。．．．．.．。。。.．．。..。。..．.。。。.。..。21．６編輯錄制的代碼.。。。。。。.。。。．.．.。..．．。.．。.．。．。。。。。..。..。。.。。。.。。．..。..。。。。...。.。．。.．。.。．.。.。．．．..。．.。..．．。.．。..。．。。。.．.．..。．..。。．..．。．31．7錄制宏的局限性．。。。。。.．。。．。。...。．。．。。．..。。.．。．..。。.。。。.。..。．。...．。。.。。。．。。。．。．.．..。.。。.。。．。...．．。.。..。。．。.。。.．。..。。.。...．。。．。.．.．31。8小結.。..。.。。。．。.。。。。.。..。。。。.。。...．．..。。。.。。.．。.．.．.。。。．.。..．。.．.．.．。。。..．.。.。．.．..。．．。。。。。．。.。。。.．。．..．．...．。．.。..。.。．.．。..。．。..．．.。。。..。。.．．。.3第二課處理錄制的宏。.。.．。．。。．。．。.。。．.．...。．．。。.。。．。．.．．.．．。．..。．.。。。．..。．。.。。。.．..。。.。．。。..．。。.。。。．.。．。。．。..。.．。。.．。．．。。．。.。．．.32．1為宏指定快捷鍵。.。.。.。。．．.。.．。。.。。.。．．．。.．.。。..。。。。.。.。．．...。．。。．.．.。.。．．。．。.。。..．。。。。.．。．.．。...．.．。．.．.．.。..．．．．。。．.．。.。．。．。．。。.。．．.．..。32.２決定宏保存的位置.．.。．..。..．。.．.。...。..．.．．...。。.。。。．．.。。．。。．.．。..。．．。..．．．。..。.。..。。．...．。．。。．。。..．。。.。..．。。。．..。.。．。.．．.．.。．。。.42.３個人宏工作簿。。．．.。．..。。．．..。.。.。..。．．。..．.。.。。。．．.。.。..。。。。。。．。。。。.．.。..。.．。。.。..。．。．。...。.．。.．。．.．．。．.。.．。．．。。.。。．．。。．。..。．。。。．。．4２。3．1保存宏到個人宏工作簿。。。..．...。．。。。．。...．．.．.。．．。。。.。。。。..．。.。。。。。.。。．.４2。3。2使用并編輯個人宏工作簿中的宏．．．.．。.。。。...．。．．...．．．.。..．．。。.。.。。。。42．4將宏指定給按鈕。。.．。.．.．．。.。．．。。.。．..。。。。．。。．．。。。...．..。.。.．.。．。。。.。。．．。。。．.。。．.．.．。．．.。．。。。．．．。．.．.。..。．．．.。。..。.。...．．．。．。..。42．5將宏指定給圖片或其他對象．.。．.。。。。.。.。。。．。．。．．．。.。.。。..．.．.。。．．.．..。...。.。..。。..。.．。..．.。。。.。．..。．.．..。..。..。..。．。...。。５２。６小結.。．．.．。．.。.。。.．．．。...。。..．.．．..。.．．。.。。。．．。.．.．．．..。.．。.．．。.。.．..．.。。...。...。。。。...。。..。。.。。．.。。．．.．。..。.。.。.．。..．.。．.。..。。.．。。。.。．..。5第三課學習控件。．.。．。．．。。.。。。。...．．..。．。.．。．.．．.．．。。...．。。．．．。.．。。．..。。.．。.．.。.．。。．。。。..。。..．。..．．．..。。．...。.。。.．。．。．.。．。53。１EXＣEL開發(fā)過程簡介。.．．．。。..．。.。...．.。...。．．。。。。．.。．。.．．。。．．...．。。.．。．．。.。.。．..．.．.。。．．．．．。。．。．.。。．..。.．。..。.。．.．．.．．。.．.．。。...。．。．53。2認識不同的控件。。．．．．.。。。..．..。.．..．．。．.。.。．。．。。.．。．．。．.。．.．。．.。。．。.。.。。．.．..。．。。。.．。。。.。．。.．。．。..。.．．．。．．。。．．.。.。。.。．．．.．.。。．.。..。。.53．3向工作表添加控件..．。。...。。．。．.．．.。.。.。。.。.．。.。。...。。．．．．..。．。...．。。。。..。。．．.。。.．。。.。．..。.．．。.。。。．．。...。．．.。.。。。.．.。．...．。。。．．.。．。.．．．.63.4設置控件的特性．。。．。。．。.。．。。．．.．．．。．.。.。。。。.。.。．..。。．.。.。.。。．。..．..。．。。．。。．。。．．..。。.。。．。.。。.。．.。。．。．．。.．。。．.．。。.。。.。．．．。．．。.．。．．..．.．。．.。63。5給控件命名。．．。。...。．.．．。..。。。..。．.。。.．..。。.。.。．..。。。。。.。．。。。.。．．.。。。。...。．。．.。..．．．。。。。。..。。。．。．.。．．．．.．．．．.。。。..。．.．。..。.．．.。。..。.．.。６3.6使用用戶窗體。．．..。。.．.。。.。．。。．。．.。.。。。。．。．...．。。.。。。。。．．．.．..．.。．．。。..。。。．．。..．．.。.。.。．。.．.。.．。.。。．。。...。。.。.．。。...。。。。..。。．．．.。.．.。。。63.7疑難解答。．.。.．。．。．．..。..。.。。。．。..。。。。..．.．。.。.。。。。。．。。.。．．.。。．．.．。。。．。．。。．..。.．．...。．。．。．..。．。.．..．。..．。．。。。．.。。..。。。.．.。...．.。.。..。。。。.７第四課理解變量和變量的作用。.．.。。．。。...。.。．．.。．。。.。．。。..。..．...。..。.。．...．。.。。。。。。。．..。.．．。．。..．.．。．。.．.。.．..。。.。.．。.74.１代碼存在的位置：模塊.。.。。..。．．．。.．.。。。．。。.。。。．。．。.．.。。．．..．..。。.．．..。。．。..。．。。。。。。。。。.．。．．。.。。．。.。。．．。．。。．.．.。。..。。.．。.．７4．2對模塊的概覽．.。..．．.．．..．.。。。。。。。...．。。。．。．。。。。.。..。．。...。..。。.。.．.．。。。。．．.．.．．。.．．.。。.。。.．..。.。．。．。。．。。.．．．.。..。.。.。。..．。。..。．。.７4。2.1創(chuàng)建過程.．。。...．...．．.。.．。.．。。。．..．..。.。。．.。..。．。。．。...．。.。．。。.．.。。。.．84.2.2運行宏．.。。。..。。。．.。．。．．...。。..。．..．．。。．.。。．。..。..．。.9４.3保存對模塊所做的改變。。.．.。..．.．．．．.。．。..．。．。。..。．．．...。．。。.。．。..。..。。．。..．.。。。。。。．。。...．。。。．．．．.．．．。。..．.．.。。。..。．。。.．．．．.。．。94.4變量。.．.．..．。。。．.。．.．..。。.。．.．。...．．.．。.。。.。。。.。。..．．．．。。。．．.。．。．．.。。。。。.．．．..．．。.．..。..。。．．。。.。.．.。。。．．.．。。.。．．。。.。。．．。..．．。。94。4.1變量的數據類型．。．...。.．.．.．．．。.．。.。.。.．。。.．．．.．.。。..。。。。．。．.。94.４.２用Ｄim語句創(chuàng)建變量(聲明變量）.。。。.。..。。。．。。.．。．。。．。。.。。．．...。..。．。.．。．.1０４.4.3變量命名的慣例。..。。..．...。．．.。。...。．..。．。...。．.．.。．。。.．。．..．.．。。．104。4.4使用數組．．.．.．．.。.。。。。。。..．.。．。。.．...．.。．。..．。。．．。．。．..．。.．。。．．。。.．。．１04．4。5變量賦值。.．．。。。。。..。．.。．..．。。.。。．．．．.。.．。。。。.．..。..。。。。.。...。.．.。。.。．11第五課利用VBA設置工作表使用權限.．。.。。...．。．..。..。.．。。。。．.．.．。。。.．..．.。．。。。..。.。。．.。。．．．。.。。.。。．．...。．.．.．。．.。..。..1１1。使用WITＨ語句..．.。.．..．。．。。。..。．.．。。.．。．。.．.．．。．．．.。。..。..．.．。．..。．.．．。.．．．。．。．。．...。.。.。。。.．。．..．.．。..。2．使用對象變量.。.。。．．。。。．．..．.．。。.。。..。。。．．．。。．。..．..。。．．.．.．。．。。．。。.。.．..．.。.。.．．．．。...。．。。.方法3：減少對象的激活和選擇。．．..。..．。．．．。.．．．。。.。.。．..。．.．.．.。．.。.。.．．.。.．．。。．．...．..。.。.。方法4：關閉屏幕更新.．．.．．。。.．..．.．。.。．.。．。.．.。．．.。.。。。．。。...．.。.。.。。...．。．.．。。。．．．．。．。.。。．。。第六課提高EＸCEL中VBA的效率。..。。.。..．．．。。．.．。.．．．..。。．．．.。.。．．.。。．。..。。．..．。。.．．。.．。．...。。。。.。。。.。。...。。。.．。.．。...１2方法1:盡量使用VBＡ原有的屬性、方法和ＷＯRKSHEET函數。。.．。。。．。．。．。。．．。。．．．..。。．．。．。。。．。．．。...。．。。...。。..。。。．．12方法２：盡量減少使用對象引用,尤其在循環(huán)中．。。。．.．．。.．．...．．..。。．。.。。．.。．。。。.。。。．．．.．．。。.。．．。。..。。．．..．.．.。．．．。。１21。使用Wiｔh語句.．.．.。。..．.．．。。。。。。．．。..．．。..。．..。．。.。．。．．.．.。。．..．。。。。。。。.122．使用對象變量。．。．．.。.．．。．..。．。.．..．.。.。.。。．．。。．．．。...．．。。．．。。．.。。。．．1２3。在循環(huán)中要盡量減少對象的訪問.。。。。.。．。。..．．.．。．.．。。。．。。。．.．。。．.．１３方法3：減少對象的激活和選擇．．.。..．。。.。..．。。.．．.．．。..。.。．.。．．。．．．．.．..。..．．。。。.。。。.．..。.。．。．。．。.。。。.．。。．。.。.．。。．．.。。．。.。.．．.1３方法4：關閉屏幕更新。。..．。.．.．。。。．。..。.。.．。。．。.。.。.。.．．。。.。.。.。。．..。.．..。．．．.。。．．。．．．．.．。．.。..．.。．.．.．。．。．...。.．。..。．．。。．．．．。．.。.．．。13第七課如何在EXCEL里使用定時器..。.．..．..。.．。。.。.．。。。。。．。。。。．.。．..。．．.。．。。。..．。...。．．.。。..。...．。。...。。.。.。。...。.。。13三、學習微軟EXCEL20０2VBＡ編程和XML,ASP技術.．.。..。.。。..。。.。.。．．.．。．。。.。．.．。．。...。.。．..．．。。..．。．．。。15第一章電子表格自動化簡介和了解宏命令。．。。.。.．。．。...．..。。.．.．.．.．.。.．.．．.。。...．。.。..。。.。.。.。..。.。..。。。。．.。..。。。．．1５1了解宏。。。。．．.．。..。.。.．。。.．．.。。..。.。．.。。。。．．..。.．．．．.．.。。。.。．.。.．.。．．.。。．。．.。。．。。..。..．．。..。．。．。..。．。..．。．.。。。．..．．。.。.。。.。。.．.。。..．．．.．。．1５2宏命令的普通應用.。。。。.．．．。．．．．。.。.。．．.。.。。．...．。．..．．.。..．。.。.。。。.．。.．。.。．．。．。．。.。．．．.。。.．．.。。.．。．。．．.。.。．。．.．.．.．.。。.。...。．.．。．15３寫宏之前的計劃。．．。。.。.。。.．。。．.．。．。.．。．．。．。.．..．。。．。..．．.。.．。。。。。。。..。。．。。..。．．．。。。。．．..。..。。.．。。.。。.。。．.．。。。。。。.．．.。16４錄制宏。.。．。.。．．。..．。.。。。。..。．。..。.。...．...．.。..。。。．.。。。。.。。。。.。.．。..。．。..。.。．.．.。.．。。..．..。。．.．..。．。．.．。．。。.。。.．．.．．.．。。．。。...175運行宏。.。.。.。。..。．。。。.．．．..。.。.。.。。。．。.。。。．..。。。．．．.。。。。．。。.。..．。。。。。．．．.。。．．。。..。。.。．．。。.．.。．。。。.。...．。。。.。.。.．。.．。.。。..。.．。。。.。。...18６修改宏代碼．.。．。。。。。。。.。.。..．.。．．．．.．．...．.．..。.。。.。。.．...．.。．．.。．.．。．.。。．．..。．。．．..．。.．.。。.．.。．.。。.．。..。.。.．．。。。.。．.．.．。。。．．。197添加注釋．。。。.．。．..。.。。。．。。。..．。。。．..．。．．．。。..．.．。。.。．．..。．。.。．。．．.。．。.．．。.。...．.．。。.．。。。.．.。.。。．。.。.．．..．..。。.。．。。..。.。...。..。．。。．。21８分析宏代碼..．。.。．。.。．．.。.。..．。．.。。．.。．.．。。..。。。.。.。。。。。．。.．．...．．。．．．．。．。..。。.。。。．。..。．.。.。。.。。．。。．。.。．..。.。.。。.．。.。.．。。．。.。．229清除宏代碼。．．.。.。．。.．。.。．..．．。。.。．。．..。.．.。．。。。．．.。。..。。.。．.。．..。。．.．。..．。.。.。.。。.．。。.．．.．．．.。.．。..．．。。。。。...。..。.．。.。...。.。。．．..．。..2３１0測試修改好的宏。。.．．。。.。。.。。..。。.．。...．。.．。．。。..．。。。。.。.．．.。。.．.．。．..。．..。．.．．.．.。．。．.。．.。..．．.。。.．.。.。．.。．。。．。.．。.．.．．。。..。。2411兩個層面運行宏的方法.．．..。..。。。..。。。．.．。.．。。．。..．.。。.．．。。。.。..．。．。..。。.。．.。．．.。。．．.。。．..．..。...。．．。．。.．．。。．。。..．．．．.。。。。24１2完善你的宏代碼。。。..．。．.。．.．。．。。。。．...。.．。。..。．。．。。。。..．。。．。．.。．。.。。。.。。.．．。。．．．..．。..。．。...．.．。..．。．。。..．．.。。。.。...。。。。.。．.．。．.。。..。2513重新命名宏．。．．.。。。．.．．.．.。.。。.．。．．．。．..。。。..。。.。.．．。.．。.。..．。．。．。。。。．。．.。．.。．.。。。.。．。...。．。..。.。．..。。。..．..．。。．..．．。．。．.．。．。。．.。。...。．．。2７14運行宏的其它方法．..。。．.。。．。．。．.。。．。..。。．.。.。.．。。.。。．。。.．．。．．．。.．.。.。。。。．。。．．。．。.．..．．。.．。。。。..．．．。.．。．.。..。．．.。。。．。．.。。..．。．.。。。．2７15使用鍵盤快捷鍵運行宏...。。。。.．．。．。.。.。。．．.。。.．。.．。.．。。．。．..。。。...．..．...。.。。..。.．。．．..。。.．。.。.。.。。。。．．。。．．．.．．。．．．.．。．．．．..。．。。。．。。2716通過菜單運行宏。。...．．。。。..。。。．．。。.。。。.。.．。.．．..．.。．.．.．。。．.。..．。.．．...。。。..．．．。。．。。．..．。．。.．。..．。..。。。。。.。.。。。．。．。.．..。．..。。。..。．．.。。。..2817通過工具欄按鈕運行宏.。。。。。．。.。。．。．．...．。．。。．..。。..。..．.．．．。．。．。．．...．.。。..。.．。．...．．..．。．。．。。．。.．.。．．。.．。.．．．.。.．.。．．.．．.。301８通過工作表里面的按鈕運行宏．．。。.．.。。。...。．。.。。。.。．...。。。..。．..．．。。。..。.。。.。。．。。。．．.．．．.。。．.。．.。.．．。.。.。。．..。．...。．。。。．．..31１9保存宏..．．.。．。.．。.。。。。．.．．。．。。.．。。．.。.．。。.。。．。．。．。.．。。。。。。。。。。．...．．.。．.．。.．．．.。.．...．。．．．.。..．。．。．。。。.。。。..．.。.。．．．。。。．.．。.。。.．...．.．。.．.。．.。。。３２20打印宏..。。.。。...．。。。。.。．...。．。.。．。．.。.。．。.．.。..。.。．。。．．.。．。.。..．．．.。。.．。．...。。．．。。．.。．．。.。．.。．。．..。．。。。。.。...．。.。...。.．。．.。。。．．。。.。.。。.．。．..3221保存宏在個人宏工作簿．.。..．。.。..．.．。。。.．。.。。。。...。.。.。。...。.。.．．.．．．．。。。。．..。．.。．。．。。.．。..。...。.．。。。．。.。。．。。。.。.．..。．.。。.。.。.。.．．。。３22２打開含有宏的工作簿。.．。.。。．。..．。．。．.。.．．。..．。．。．。。.。。.。.．。.。．。．。。．...．.．。.。。。．。。。。．．。。．。。。.．.。．.。．．．.。．．。．．。.。。..。．．.。。。．。。。．3423ＶB編輯窗口.。。.．．．．。.．.。．.。.．。。。．.。。．..．。．。.．.。.。.．...。.。。。。。．..。.。.。。.．。.．.。.。.。．..。。。.。...．．。。。．.．．.。．。...．。..．.。。．．.。．..。．.。。.。。.．。。.3524了解工程瀏覽窗口．．...．。．。.．.．．．.。．。.。．。。．．.．。.．．。。.。。..。．..．．．。...．.．.。.。.．.。。.。.。．。。。。．。。。.。．。.．.．。。..。。．.．。．．．。。。。．。。．。。。。.．。．35２５了解屬性窗口．。。。．.．..。。。.。．...．。．。。。.．。.．...。．．．。．。..．。．．.．。．.。.．..。。。。.．．．。．．.。．。。。..．。..。..．。．.。．。．。。。...。。..。。..。.。.．．。.。。。.3６2６了解代碼窗口。。。...。。。．。.．．。.．。...。.．．．．.。。。.。。.。.。.。。.．．．.．。..。．..．.。..．..．.．．。...。．。．.。。。。..．．．.。．．．。。。．．.。。。。...．.。。.．。.。．。。.．．．。。.．。..．３6２７VB編輯器里的其它窗口．。...。。。。.。。.．。.。。。..。．。.。。.．。..。.．．．．.。．.．...。．。.。。．。．.。。．。...。。。。。。..．。。。。.。.。。...。...。。.。．。。...3８28接下來……。.。.．。．．。。．.．．．．。．。。．。...．.．。.．..．。.。.．。。。。．..。．。.．..。．．。。.．。。...。.。。．．．.。．。．．..．．。.．．。..。。。.．。.．。．。.．．...．.。.．。.．．。．..。.。3９第二章VＢA第一步.。．．..。．.．。。..。.．.。。.．。。。.。..。..。.．。.。.。．...。。..．。..。．．．。。。。.．。。．．。.．．。．。.．．．。.。。。.。.。。.。．...。.。。．。.。．...。..．.39１了解指令,模塊和過程...．。．.。。．。.．。．..。。..．.。。．．．.．.．。．．。.。...．．。。。.。..．.。。．。．．.。．.．。...。.．。...。．.。..．。.。.。。．．．。．。..。。。．．。.。。．...３９2VＢＡ工程命名。。。。.．.．．。。。．．。。..．．..。。.。.．。．.．．。..。..。.．。．.。．。．。.．．.。。.。。．。。.。..。。。。。.．...．．.。.。.。。．.．。。.。。。。．。..。...．．．.。.。。．．。。．.。。393模塊重命名.．．。。．.。。．。。...．。．。．。．。。.。。．。.。。。．。。．。。...。.．。.。.。。。。。。．..．。.．..．..。。。．。．..．．。．...。．。.。．.。.．..．.．。..。..。。。。．。.．。..。..4０４從其它工程調用過程。.。。。。。。．。.．。．．..．。．...。。。。．.。.．..。.。.。.。．.。.。..．.。.．..。。．..。.。.。。．．。.。。.．。．..。。。。.。.。。.。...．..．.．.．。..。.。。．４１5了解對象，屬性和方法..．.。。。。．。.．。.。.．。．.。..．.．.．。。．..．...．．．．。.．。。..。．。.。。。.。．..．.．。。..．。.。．。.。.．..．．..。.。。．.。．。。.。.．。...。．。４２6學習對象,屬性和方法。...。．.。。.．.。.．。..．.．.。．..。.。。..。.。。.。．...．.．。..。．。。..。．...．..。。。..。。．.．。．．。．。．。．。。．。。.。。.。.。...。。.．.．.。４37句法和文法.。..。．。.。。..．..．。。．。。.。..．。。．。.。．．..．.．.。.．。。。.．.。..。.．..．.．．．。。.。.。.。。。.。。．.．.．。.。..。。..。。。．。．。。.。。..。。。．.。．．。.．。。。４58打斷很長的VBA語句。。．。．.。．．．．。．。。.。.．.。。。．。．.．．。.．..．．...。.．。。．．。。.．。．.。.．。。.。．.．．。.．..。．.。．。。。．．．。.。．．。．.。.。。.。。..。.．．.。。.。.。．..。。．４７9了解ＶBＡ錯誤．．．。．.．。．。。．．。.。...。。..．.。。。．。。..．．．．。..．.。。...。．。．..．。．..。.．．。。．。.．．．．..。.．。..。．。..。。..。.．。.．。．。．..。.。...。...。．。.．.。．。..。..。..．。。4710查找?guī)椭?..。.。.。..．．．．。.。..。．．．。．。.．．。.．。．..．...．.．..。。.。...。.．。。．．．。．。。.。。.。.。..．.。。．。．．。．．.．．.。。.．．。.。.。.。。。.。。..。..。.。。。。。。。...。.．．.。4911語法和編程快捷助手．.。.。.。。.。．。.。。.。.。．..．．．．。.．.．.。。。。。．...．。。。。．.。．．．。...。．．。。．.．．.．.。.．。。.．.。。.．。.．．．．。.．.。。。。..。。。。。．。.。。。5012屬性/方法列表．．。。.。。.．．.。.。..。.。．。．。。..．。。。.。。。。．..。.。.．。.。..。..．。。.．．．．.。..。．。．.．.。...。。。.。。..．.．。.。。。...．。．。.。.。．.．．。...。．.。..．.．。。5１13常數列表。。。。.．.．。。..．。..。．．.。。。．．。．.。。．。.。.．.．。。.．。。.。.．.。.。．..。..．。。．。..．.．。．.．。。。。。。。．..．．。.．。。．。.。.。.．。.。。.．．.。．。．．．．..。。.。..。.。..511４參數信息。。．．。。.。。..。．..。.。．．.．.．.．。.。...．.。。．.．...。.．．。。.。。.。.。．。．．.。..．。。.。。.．．．。．．。。．。．。。.．．。.。。..。．．.。。.。．。..。..。..。。．.。．.．。．..。。。．。。．。5215快速信息..。。.．..．..。．。。.。..．.。.。..。．..。．．。。。．．．。。。.。.。。．．...．．。.。．．.。．.。。．．．。...．．．.．。。。。．．．。...。。。。...．.。。.。．.。.。．．.。。．.。。.。。。.．。．．。.5216自動完成關鍵字。．．.。..。。。.．．...。。．．。...．．..．．.。..。.。...。.。．.．。.。。．.。..。.。。。.。．。。。。..。.。．.。．．。．。。．．．。。..。..．．。。.．..。．。...。.．.。。．．．..．.521７縮進/凸出。．。。。.。。.。．。．。。。。.。。。．。．。。.。.．...。。.。。。。...．.。...。。。。．。．．。．.．..。．。.．。.．．．。。.。..。．。。．．。．。。.。．。.。。．。。...。。。.．。。.。．．.。．。。。..。...。。...．。5３18設置注釋塊/解除注釋塊．.．.。．．．．．。。.。．。.。。．．．.。。．..。．..．..。。．．。.。..。．．．...．..．．...。．。．.．．。.．。。。．。.．。．．。。。。。.。．..．。。．。。．.．。。。．．..．.．5319使用對象瀏覽器.。．.。..。．。。。。...．.。.．。.．。。...。。。.。．...．。。．。．．。．。。.．.。．．.。.。。。。．．.．...。..。...。。.．。.。．...．.．．。。．。..。．．...．．.。。．．。．。.。．５３２0使用ＶBA對象庫.．..。．.。。。.．。。。．。...。。．．。．.。。。。。.。.．。．。．..。.。．．。．...．.。.。。.。.。.。.．.。。。．.。。。.。．。．。．。。.。..．.．．。.。．。．。...。。.．．。582１用對象瀏覽器來定位過程.。。。。。。．.．．。．。．。..．．..。．。。.．。..。。.。..．.。。。．.。。.．。。。．．．。。．。。.。.。..。。.。。．。..。。。。.。。.．。．。。。。．.。.。。．。．．．。。5922使用立即窗口..．。。.。.。。．。。.。。.．．。.。.。。.。。。..．..。．.。．。．。.。。。。。..。.。.．．。..。．。.．.．．..。.。.。.。．.。..．。。.。．．。..。。.。.。.。。．.．。．．．5923獲取立即窗口里的信息。。。.。。.．.。.。．.。．。。．..。。．。。..。．.。．．。．．。.。。.。．.。。。．。。．.。。.。．。。．.。。...．。。．．..。..．.．．.。。..．。．。.。。..。..。.。．．．...．。．6１2４學習對象..。.。..。。.。。..。..。.．..。．．．..。。。。．.．.。．。.。。．.。。．.．...．．．。。．...。．。．。。．.。。．.．..。..。．.．．.。.。。．.。。。。．。.。．．。．。。.。。。。．。...．．。...6２25電子表格單元格操作。。...。.。。。。。．。。．．.。.。..．。．.。.．..．.。．.．。．.。.。．.．．．．.。．。．．．.。．．．。...。。。。．．．。。。。．.．。.。。.。。．。．．.．。。．。．．。.。。。。．..。．..。。６226使用RANGE屬性。.。.。。．。...．.．.。.．。。.。。．.。．。。.．.．.。.。.。．。.．..。．。。。．.．。.。。.。。．.。.．．。．。．。。．。.。。。。。..．。..。。．．.．。...．。.。.．．.．.．。..。。。.．。。。．。。.．。。。62２７使用CELLS屬性。。.。。。。。。。。．。。。..．..．.。.．..。。.。.．。．。。.。..。．．..．．。。。。.。.。。.。。...．。..。。.。.．。．.。。．.。.．.。.。。．。．。。.。。．。．.．。.。..。.。．。．...．。6２2８使用OFＦＳEＴ屬性...。..。．．..．..。。。.。.．．．．．。。。。.。.。。.。。.．。。。.．.。。．。..。。.．..．.。.。．．.。..。..。．。。..。...。。．。.。。。。。.．．．。。．．。..．．..．。。．。．6３29選擇單元格的其它方法..。。。。.．．..．．．．．.．．。。..。。。．。．..．．．。．。...．。．。。。..。..．.．。..。。。．。.。。。。。.。。。。.。.．．。.。．.。..．．。．。．.。．..．。。.．.。.．6４3０選擇行和列。。．..。..。..．.．。。.。．。．。．．。。。.。。。。．。．.．。．..．。.。．.．.．.．。．．．．。.。．。。..。.．。。.。．..。。．。.。.．。．．。。．。。。.。。。..。。.．。。。。．。．.．。．.．.．.。..．６431獲取工作表信息。。。．。．.。。。.。．。。．。．．..。.。。...．．．.．.。.。。．..．。．。。。．。..。。。。。．。.．.。．.．。。。..．。．．。.．.。..。..。.。。。。。。．.。..。。．..．．．..。．．.。.．65３2往工作表輸入數據．..。。..．。.．.。。..。..。..。．.．。．.．。．．．．。。．．.。。。．。。...。．。．..．．.．。．.。。。..。.。.。．。。。.。。..．...。。。.。...。。．．.．..．。.。。..６533返回工作表中的信息.。。。。。．..。。．。。．．．．。。.。。.。..。。。。。．．。。...。．。。．．．..．。。.．．。.。.．。.．.。。。.。。。．。。。.。.．.。。。.．。。。.．。．．。。.．.．．..。．..．6534單元格格式..．。.。.。。...．.。。.。.．．..．。．.。．．.．.。...。．．.。．。。.．．.。.．。。．..．.．...．.。。．．..。..．..。.。．.。.。.。．。。。．。．。．..。.。。.。．.。．.．。．。.。．.．。。。.．。。6635移動，復制和刪除單元格．。.。.．。。。.。．.．．。。。。。．。。...。．．．..．。。。。。．..．..。.。．..。.。.。。。．.。.．．...。..。.．.。。.。．．。.．.。.。．．．6６３６操作工作簿和工作表.。．．.．．...。．...。...。。..．．.．。．。。.．。．。.。.。。.．.。。．。.．。。。．..。.．。。．。.。。．。。。.。。。.。.。。..。。..．。。。。。。．．．..。。..。。。673７操作窗口（WIＮDOWS）。..。．．.。.。.。。..。。.。..．。。。．...。..。。...．。。..。...．.．。．。.．。．...。。.。。.。．．.。.。..．..．。．..．.．。.．。..。。。..。．.．.。。．.。．．．..６73８管理EXCＥＬ應用程序.．。。.。．．。．.．。。．.。..。．。。．。.。.．。。.．．．..．.。。。.．.。。.。..。。．．。．。.．.．.．。。．。..。.。。..。。。．.．．。.．．。。．．．...．.．．...．。..。.。．．..．6839接下來……。.．。。。。．..．.。..。。..．。..。。.．．。。。。。.。。．．．。．。.。。.．.．.．。。.。．。..。。..．．．..。.。.。。...．。.。.。..．．。。.。。。．。。。．。.。。．。.。.．..。.．.．..。.．。.68第三章了解變量,數據類型和常量..。..。。．。.。。.．.。。。。．。.。。。。..．.．。。．.．。。．.．。．.．...。。。.。.。.．。.。.。.。.。.。。.．。．..。．.．。。691保存VBA語句的結果..。．。。.．.。.．..．.。。。．。．。。..．。.．。.．．。．．。..。。．。。.．。.．。.。．.。．。..。。．．。．。。..。.．..。..。.。.。。．．.。。.。.。。.．.．。。..．．.。．.．．692變量是什么。.。.。.。．。．..。．。．．。．。．．．。。．．.．．..。。...。。.．...．..。。.。.．．．。．．.．。.。.。。．．。.。..。.。。.。。..．。．．．..。。.．.．。。．。。．..．...。。。.。．。．.。.。。。６9３數據類型。。。.。.．．．。..．．.。。。。．。。．．..。.。．。。。．．．。..．..。．。。。。。..。.．．..．．..。。。...。..．。。。。。.。。。...。．.。。．。．。．.。。。．。．.。。。。.．。.。。.。...．.６9４如何產生變量.。..．。..。。.。。...．．．．..。.．。。。。．.．。．.。。。.。.．。．．。．。.．。.。.．。．。。.。．.．．.。..。.。。。.。.。.。．。.。..．。。。。.。。.。。。．．.．...．.．..．。。。..．。。．。。.．．。..７０5如何聲明變量..．。.。.．。。．．．。．.．.。。..。。.。.。。。.。．.。..。..．。．。．。．．.。...。.。。。．．。.．．.．．..。．。．．．。。。．.。。。..。．。。。．．.．。．。..．。。。。...。。.．...。。．。。.。。.．716明確變量的數據類型。。.。。。.．．.．..。。..。．。。.。。.。。.．。。.。．．。．...．..。．.．.。．...。.．..．.．．。.。．。．．。．.．。。.。.。。。。。．。．。.。.．。。.。。.。..。..。．.。。。．.。727變量賦值．．。．．。。。。．．.．．.．..。．．．。．．。．.。．。..。．。...。．..．.。．..．.。...．.。。．..。.。。．。.．.。。..．。．...。。.。．。．...。。.。.．。。．.．.。。。．。.．．。．。．．。．．．．.．。．．.73８強制聲明變量．．．。。。．．。。。。。．.．．.．。。。.。.。．。。.。．..。。。。.。。。。.。.。。．．。。。。。.。。．．。．。。．．。.．。．。．。。..．。.。.．.。。。．．.。。．。.．．。.．。..．．.．.．.．．。．．.。..。．.。.75９了解變量范圍.．.。.。..。...。.。。。.。.．。。。．．...．.．.。..。..．。。．。。。．。．。...。。.。.。。。.．.。．。。.。．．。..。.。．。.。.。．。.．..。..．．.。..．．．．。.。。．..．。．.．。.。．...．.．。.。７610過程級別(當地）變量。.。．...．。...。．．.．.．.。．．．。。．.．．.。.。。。。。．．..。.。。。．。.。．．．．。。。..．.．。。。。．..．．.．。.。。。。.。．..。...。．。．。。。..。..７611模塊級別變量．.．．．．。...。。.．．。．.。。．。。.．。．。．..．.。．．.．．。。..。。。。。.．..．..。。．．．。．.。。。．.。。．．。.。．..．。．。..。.．..。。。．。.。.。．..．．．．。。．。．.．。。．..。．．．7７12工程級別變量．．。。..。.．．.。．。．..。。..．。。.．．。。。．。。。．。。。...．。。。。。．．...。．..。。..。。..．.。.。。..。。..。．.。...。。。。.。．．。。..。.。.。.。。。。．．.。。．.．。。.．。。。..7713變量的存活期。.。．．.．．．．.．.．.。。．．．..。.．..。。.．..。．。。.．.．.。．.。。.。．．．。．。。。．.．.。.。。.。．。。．。。。.。．．.。。。．.。．。.．。.。．.。。。。。．．.。．。。．..．.。.。．。.。．.．7814了解和使用靜態(tài)變量。．。.．。.。．．.。。。。。.。。。．．。.。.．。。.。．。．。。...。．。。。．。.。.。.．．。．。...．..．．。．．.。．..。。．．。.．．。．。.。.。．。.．。。．..．。。。。.。．．．．...7８15聲明和使用對象變量．.．．...．...．.。．。.。．．．.。..。．．。。．.．。.。.。。．．。.。．。..。.．。。.。.．。...。。..。.．.．..。．．。..．.。。．。.。。。。。。．.。..。．。。．。.。..．.．．。.．.7９16使用明確的對象變量。。.。..。。.。。．。．．..。.。。。.。。。。..。.。...．.。。.。.。.。。..。.。。..．．.。.。.．..．．．。。..．。．。.．．。.。..。.。.．。.。。。.。.。．。.．．。．．。..。.８０17查找變量定義．.。。。...。．。..．。..。．。.．.。.．．。。。．.。．..。...。。．．.．。．...。..。．。..。．。．。．.．．．.．．.。...．.．。。．.。。。.。.。。..。．．。.。.。．．。．．。...。.．..。.。..。8018在VB過程里面使用常量.。。..．．.。。。.。．.。。.．。。。．．。．..。．..。.。。。。．。。..．.。。.．。．．。..．.。。．．．...。。．...．．.．.。.。.。.。.。．...．。.。．。...．.．..。.。..。。80１9內置常量...。．。．．..．.。．.。．。。。．。。。。．..。．。。。。..．。..．。.．．.．．．。.。．．..．.．..．..。．。．.．.。。。．．.。．.．.．.。..。.．。.。...．.。。..．．．.。。。．。。.．。..。.。．.．。..。。.．812０接下來……..．.。。...．.．．..．.。．．...．。．。..。.。。。．。..．...。.．...．．．。.．．.。..．.。。。。..．。.。.。。．．。..．。..。。..．.。。．。.．。.．．。.。。。．．．。.．．．．。.．.。．。..82第四章ＶBA過程：子程序和函數．。。。．.．。.。．．.。.。..．．..．．．．．.。．。。．.．.．．.．。..．。。.。..。.。．。．...。．．.。。.。。。。。．．．。．。。。。.。。．。。．。。。821。關于函數過程..。.．。.。.。.。．。。。.。．。．..．。.。。。.。。.．。.．。.．。.。..．..．。。.。．。..。.．．．。.．。。。.．．．.．．.。..。．..．.。．．．...．.。.．．。．..。。．..。。。。.．。。。.．．.。..．.。。８２２.創(chuàng)建函數過程。．。．．..．。..．.．．.。。．。。。。。。．.．。．。。。。。。．.。.。。。．。．...．。．.。.．。。．。.．．。..。..．。.．.。..．.．。..。.．.．。．．。．。.．。.。。...．。.。。。。。．。..82３。執(zhí)行函數過程.。．..。。。.。..。..。。。．。.．..。。．.．..。...．.．。.．。．．.．．．．..．.．...。。．。.。。．。。..。。.。。.．．．.。．.。..。．．..。.．.．。.．。．．．。.．.。.。..。..。844．從工作表里運行函數過程..．.．.。．。．．。.。..。。.。...．...．。．。。．。。。。。．.。。。．.。。。．。。。。.。．.．.．。．。．．。。。．。。。。．。。.。．．．.。。．..。。.。。.。..．．。．．..８４5.從另外一個VＢA過程里運行函數過程。.。.．。.。...。.。...。.。.．.．.．...。．.。。。.．．.。。.。．.。.。．．。．．。...。..．。..。。．。..．.。..。.。...．.。．856.傳遞參數．.。．..。．。.。。．。．。．．．。．.。。..．．．．...。．．。.。．.．。。.。．。。．.．.．.。．。。。。。．．。．．...．。．。。．．。.。．。。。。.．.。.．。.．。．..。．。..。.．。.．．867。明確參數類型。．。．。．．.。．。。..．.。。。.。．．。.．．．．。．．。.．.。.．．．...。.。.．．。。.。．．。。。。。.。。。。..。...。．.。．。.．。..．．．。...。．.。...。．..。。。．．．。.．．。..。。..8７8.按地址和按值傳遞參數。．.。。．。。..。。。。.．..。．...。.。．..。。．.。。。...。。．。。．.。.．.。。．．．。。。．.。。．。...．．．..。.。．．。．..。．。。．。。.。..。..．．．。。．。。.．.。889。使用可選的參數。.．...．。。．..．...．。．。．.。。．。.。..。。.。。..。。.。．.。...．。．.．.。..．.。。。．。．.。.．．．。.。．.．．．.．。.。.。.。.．．。...．..。。。。。．。．．。.。．。．.．８８10．定位內置函數。。。。..。.。．.。．．。．.。。。.。.．．...．．．。。。.．。.．.．。.。．.。．。。。．..．.．。.。。..。..。。。.．.．．.。。.。..．。.．．。.。。．．。.。..。。.．。.。...。。．...．.．。．．8９11．使用ＭSGＢOX函數.。..。．。。。。。.．...。.．．．。．。.。．..。．.．。...。..．。．。．．。...。.。．。...。。。．。．.．。．．.．．。.．．。。．..．。．．...．.。。．．。..．。．。.。。．.。．..．．．。．..。。901２。MSＧBOＸ函數的運行值..．。。.．．.。。。。.。。。．。.。。。。。。..．.．．...。。。.。..。..。。．．.。..．。。。.。..。。.。..。。..．.。。。．。．。．.．.．。．。．...。。。．．。．．.。.。。．。．..。。.．。9４13.使用INPＵTＢOX函數..。...。.。...。．。。.．．．..。.．。．．..．。。。.．...。.．..。。．.。.。．．。.。。．.。..。..．．..．。．．。.。。。..。。。。。。.。。。．。.。．..。。。。。...。。。。。．。.．。.95１4。數據類型轉變。．.．。.。.．。。．。。．.．.．。。。.。.．．．。.．．.．。。．.。。。。...．。．。。。..。．.。。。..．．。。。.．。．.。．.。．.。。.。。...．。.。。..。。。。．。．.。.。..。..。．。..。。961５.使用INPUＴＢOＸ方法．．.．。.。．。。．。..．。．.．.。．.。．．.。.。..．。．...．。。．．.。。．..．。.。。。。.。.。.。．.．。．。.。。.。.．．。...．.．．.。.．.。．..。．...。。.．．．。.。..．...．.９7１6．使用主過程和子過程。．。．。.．.。.。．。。．．。...．．.。。.。．。．。。...．。．..。。。.。。。。..。..。。.．。．。..。。。..。.．.。．。.。。．。。...。．..．.。．。..。。。...。100１７。接下來……．。。.．．.。..．．。．。。．。。.。。。。.。。.．．。.。...。.．.。..。。。.。．．。．。。.．。.。..．.。.．。．.。。.。.。。。.。.．..。.．。．..．。。..。．。．．．.。．。。．．。.。。。。。.10２第五章基于ＶBA做決定。..．。。.。。．..。.。。．.。.．.。.。。.．。．。...．．．..．．．.．。．．。．．.。。。。．．．..．。．．。。。。．。。。.。。.．..。.。..．。．。。１021。關系和邏輯運算符．。...．。。。..。。.．.。。.。．。.．..。.．。。.．。。．.．.．。..。..。.。。。．。.。.。.。．.．.。．。．。。..。。。．．..。。．.。.。．.。。．..。.。。。..．..．.．。。102２.ＩF…THＥＮ語句.。.。.。．.．。.．。.．。.。.．.。。．。.．。．.。。。．.。．。.．..。．．。。.．。．．。．。。。．。．。.．。。.。..．．.．。。。．。..。．。。.。。...．。。。.。。..。。.。．..。..。。.．。。..。。.。..。。..1033?；诙嘤谝粋€條件的決定..．.。．．.。.．..。。。．。。．.。。...。..。．。。．。.．。。.．。.．.。。.。。．．．．。...。．。．。。．.。。.．。．。..。．．．．．.．.。．。。。.。．。10５4.TＨEIF…ＴHEN…ELSE語句。．。．。．．．。．.．．．。。。.。。．..。。.。.。．.．。．．．。.。..。．.．．。。．..。．.。．...．．。.。。。。。。.。.。．.．.．。．.。。．.．.．。。.。。。．。．.．．。。。．.10６5。IF…THEＮ…ELSEIF語句。.．.。..。。..．。。...．。。．．。.。．。．.．．。．.。...．。.。。．..。..．．.。．.。。．．.．。．。。．．。。。...．.．．。。。．.．。。．..．.．．．。。..．..。．．．.．..１０86。嵌套的ＩF…THEN語句．．。.．。．。.．．.。..．...。.。．。。。.．..。．..。。.。．。.．．.。...．．。．。。．。..。。..．。．。.．..。。.。．。.．.。。。.。。.．.。..．.．...。.。。1107．SELECTCASE語句。.。。.．。.．．..．.。..．.．。．.。。。.．.。。...。..．.。.。...。..．。。.．。..．。.。。..．.。。。．.。．．。．...．。．...．.．.．..。。..。...。。．。．.．．．。。。。。.。..。.．。..11０８.和ＣASE子句一起使用IS．..。．..。。。.。.．。。。．．．．.。。。．．。.。．..．.。.。。。...。.。．。．．。。。．。.。。.．．。．。．.。。．.。．．.．。..。．.．。。.。。．．。．...．.．。．。1129．確定ＣAＳE子句里數值的范圍。．。．。。.。。..。.。。．．．。。。。。..。.。．。．．.。．。．。.。．.。.．。.．。．。．。．.．。。.。..．.．..．.．．。。。。。..。。．。。..．...。１1３10.在CAＳＥ子句里確定多個表達式．．.．．。.。．.。．..。.．..。．。。。。.。。..。。。。．。．。．。..．。．。。..．...．.。．.。.。.。。．．.。。．.。..。。.。..．.。.。..。。。..．．..。1１4１1.接下來…。。.．。..．。．。。。。.。．...．.。。。．。.．.。．。。..。。..。.．。。．.。。。.。．。..．．。..．.。．．。．。.。．．。．.。。．.。．.。．。..。.．．..。.．．。..．.．。..。.．。。。.．..。。。。．.114第六章在VBA中重復操作.。。..。．。．．.．.．...。．。。．.．．。..．．。。．.。．。。。。。。．。。。．．．.．.．。。.。。...。..。．..．...。．..。。..。.．.．..。..。114１.DOＬＯOPS:DO…WHIＬＥ和ＤO…ＵNTIL．．。.．。．。。.。..．。．。。．.。。．．．．。。.．。..。。...。。...．。．.．。。.。.。。．。．.。.。．。。．.。。．．．．.。.。.。.。。．．。。。．。.．。11４２。觀察過程執(zhí)行.．。．..．。．．。．.。．．．．..。．.．。.。.．。。..。...。。。.。。。。.．．。。.。。.．．.。。．。。.。。.．。．..。．。。。．。.。.。．。。．.。.。。.．.。..。...。．.。。。．．..．..．。。。。.１173.WHILE…ＷENＤ循環(huán)。。．．.。。．。．..。。.．。..。。。。。。.．。.．。。。.。．.。。。。。。.．。。。.。。。.．。。。。。．。。．。.。...。.。。．.．.。．...。.。。。.．．。。．.．。。..。.．．。．。.。。．．．．。..．。1184.FＯR…NEXT循環(huán)。。。。。．。。．。。．。。。。.。．。．．.．.．.。。．。.。...。。．。.．。。。。．.。.。．.．。．。。。.。.．。..．.。。。。．。..。.．．..．。。..．..。。.．．.。。。．。。．...。...１195。FORＥＡCH…NEXT循環(huán).．。。。。．。。。。.。。.．.。．。。.。。。.。.．．．。.。．.。。。。。。...．.。.．.．.．。．。。。。。．.。．.．。．。．。．.。..。。．。。..。..．。。。．。。。．.．．．．１2０７。提前跳出循環(huán)..。...．．．。。.。.。.。.．。。．.。。。。．。...。.。．。。．。...．.．．。...．.。..．..．．．..。。。．．。.．。。.。。.。.。．.．.．.。。。。。。.．．.。．.．．.．．。。..。．.。。．.．.。１218.循環(huán)嵌套.。。。。．。.。。．..。.．。．。．。..。。...．.．。。．。.．。..．..。.。．。。.。。。．.。.。。...．．。。.。..。.。。。。.。．...．。。.。。．.。．.。..．。．．..．．。..。。.。..。．。。．..．。．．..。..．。。.1229.接下來…。..。。.．..．。.。。...。..．．。。。．。。.。。.．.。。．．.．．。.。。。。。。．.．。。。。．．．.．。。。。。..。.。.．。。。．。.。.．.．．。．。...．.。.。.．．。...。。。.。。。．．..。.。.．.。．。。。122第七章利用VＢA數組管理數據清單和表格。。。．..．.。．。．．。。.。。．.。.．。．。。．。．..。。.。.。。。。．。。。。．.．.。．．。．。。.．．.。.．..。。。。12２1。了解數組．.．..。.．。．．．．。．.．.．.。。。．..。。。。。。..．.．。。。．．。．。。。．。.。．。。.．．.。..。．．．..．。．.。。...。。．。．．..．..．．.。．.．..．.。．.．。．.。。。.．。．．.．．...。。。.１２３２.聲明數組.。。．．．．。．.．。.。．。...。.．。．。．．。..．..．．..。。．。...。..．.．。..。．.。.．。.．.。．。．..。。。..．．．。。。.。。.．。．.．。．．．．．。..．。。。。。。。。。.。。。。..．．.．.．１24３．數組的上界和下界..。．。．.．...．．．..。．。..。。。。。.。．.。.．。．．。。．.。。．.．．。．．。.．。。。.．.。.。。．.。。。.．。.．．.。.．．.．.。..。.．.。．．。.。．．..。．.。．.。.。.．。。。.1244。在VBA過程里使用數組。。。。．。。.．。．.．.．。.。.．。。。。．.。．．.．．。.．．．.。。.．..．..。.。．．．.。．．。．。..．。.。．．。.．。．．。.。.。。.。.．.．。。.．..。。．.。..。.．12４5.數組和循環(huán)語句.．.．。．。。..。．.。。。。。。.．．.．．。．..．．。。．..．...．.。。..．。。..。.。...．.．。．。。。.。。．。..。.．．。。.．.。.。.．。．。.。..。．．。..．．．.。．.。。.。。。.。.。．1２５6.使用二維數組。.。。．。.．。.。.．.。．．。。。.。。..。。。．。.。。。。。.。.．..。..。。.。...．.．.．..。..。...．。。．．。．。。．.．。.。。．..．．．。。．。...。.。.。。．．.。．。。.．。。。.．。.．..。１2７7．靜態(tài)和動態(tài)數組.。。。...。...。．。.。.．..．。...。.．..。..。．．。...。.。．.。。。．。。.。．．.。.．...。。。..。。．。．。..。。。．...。.。。.．。.。。..。。.。。.．.。。．.。。．.。．.．。。。１288．數組函數。.。.．。．．.．．.．。。。。..。。.。。。。。。。。.．.。．。．。.．．。。.．。.．．．..。。.。。.。..．..。．．.．。。.。。.．。．.。．。。..．.。...．.。．.。。．.。...。。。。.．..。.．.。．.。.．。.．．．．.．。．。1２99.ARRAY函數。.．...。。．。...．.．．..。。。．。。.．．。.。.。．.．。..。。。。.。。．.．。.．．。.。.。.。..。。．.。。。。．．。...。。。。．.。．．。。.．。．．.．.。．..。..。。..。...。.。.。．1３010。ISARRAＹ函數.。．．.．。。。.。．．..．.．。．。。.．.。。..。..。．.．。．。。．..。..。。.。。.．.。。。.。．。..。.．。。．．。．.。.。．.。.。。．.。。。.。．．.。.。.。。.。...。。．．．.．。。。..．．．..．1３01１。ERASE函數.．。.。..。...。．．。．。．。．.．。．.．.。.．．．。。。.．。..。。。．．...．..。．.．。．.。。。.．。。。。..．．．。．。．．.。.．。.。.。.．.。。。.。。..。..。。.。．.．.。。.。...。．．...。．。.。.13１1２.ＬBOUＮD函數和ＵＢOUＮD函數...。.。。..。．.。．...．.。．。.。.．。。。.．。.。.。...．..。。。．。。。..。。。．.．..。.．.。。.。。．.．。．.。.。..。．。。..。．。．。。．．.。．。.。．．13１1３.數組中的錯誤。.。。..．。。．...。。.。。。．..。。。.。.。。。。.。。．。..．。．.．。...。。.。..。。．.。．..。．。．。。。。。.。。.。。。.。.。.．.．．..。.．..．．。。..。。。.．..。。．。。．．.．。．。．..．13214.數組作為參數...．．．。。.。．。．...。．.。。.．。。．.．。。．．．.。．.。。.。．。.．..。.．...．.。.。．．．。．。.。．.。．.。．.。。..．.．．..．。...。．..．。.。.．．。．。..。．。..．。．.1３４15。接下來…。。．。.．。..。．.．。。.。．。．。。。。。。。.。.．。.．．。.。..．..．。。。。.。。.。.．。。．。。。..．。.．。。。．.．.．...．。．．..。...。.．.．．．.。.。.。...。．．。。．．．．.．...13４第八章利用VＢA操縱文件和文件夾．。.。.。.。.。．。．。。．。.。。.。．..．.．.。。.。．。。。...．．.。。．.．．．。。。．。．.。.．。...．.．.．.．．.．．.。..。1341。獲取當前文件夾的名稱（ＣUＲDIR函數）．。。．。．。。．．．．．。。。.．．.。.．．.．．。。..．．..。.。．..。．。.．．．.。．