【正文】 ..................................818 強(qiáng)制聲明變量 .................................................................................................................................................849 了解變量范圍 .................................................................................................................................................8510 過(guò)程級(jí)別（當(dāng)?shù)兀┳兞?...............................................................................................................................8511 模塊級(jí)別變量 ...............................................................................................................................................8512 工程級(jí)別變量 ...............................................................................................................................................8613 變量的存活期 ...............................................................................................................................................8614 了解和使用靜態(tài)變量 ...................................................................................................................................8615 聲明和使用對(duì)象變量 ...................................................................................................................................8716 使用明確的對(duì)象變量 ...................................................................................................................................8817 查找變量定義 ...............................................................................................................................................8818 在 VB 過(guò)程里面使用常量 ............................................................................................................................8919 內(nèi)置常量 .......................................................................................................................................................8920 接下來(lái)…… ...................................................................................................................................................90第四章 VBA 過(guò)程：子程序和函數(shù) ..............................................................................................91 .................................................................................................................................................91 .................................................................................................................................................91 .................................................................................................................................................92 .............................................................................................................................93 VBA 過(guò)程里運(yùn)行函數(shù)過(guò)程 .......................................................................................................94 .........................................................................................................................................................95 .................................................................................................................................................96 .................................................................................................................................97 .............................................................................................................................................97 ...............................................................................................................................................98 MSGBOX 函數(shù) ......................................................................................................................................99 函數(shù)的運(yùn)行值 .............................................................................................................................103 INPUTBOX 函數(shù) ..................................................................................................................................104 .............................................................................................................................................105 INPUTBOX 方法 ..................................................................................................................................106 .................................................................................................................................109…… .................................................................................................................................................111第五章 基于 VBA 做決定 ...........................................................................................................111 .......................................................................................................................................111…THEN 語(yǔ)句 ..............................................................................................................................................112 ...........................................................................................................................114 IF…THEN…ELSE 語(yǔ)句 ..........................................................................................................................115…THEN…ELSEIF 語(yǔ)句 ...............................................................................................................................118 IF…THEN 語(yǔ)句 .................................................................................................................................119 CASE 語(yǔ)句 .........................................................................................................................................120 CASE 子句一起使用 IS ............................................................................................................................121 CASE 子句里數(shù)值的范圍 .......................................................................................