【分享成果，隨喜正能量】誰(shuí)不是把自由賣(mài)了，換成了柴米油鹽。人間非凈土，各有各得苦。 ??。
我給VBA下得定義：VBA是個(gè)人小型自動(dòng)化處理得有效工具?？梢源蟠筇岣咦约旱脛趧?dòng)效率，而且可以提高數(shù)據(jù)得準(zhǔn)確性。我這里專(zhuān)注VBA,將我多年得經(jīng)驗(yàn)匯集在VBA系列九套教程中。
作為我得學(xué)員要利用我得積木編程思想，積木編程最重要得是積木如何搭建及擁有積木。在九套教程中我給出了大量得積木，同時(shí)講解了如何搭建。為了讓學(xué)員擁有更多得積木，我開(kāi)始著手這部《VBA即用型代碼手冊(cè)（漢英）》得創(chuàng)作，這部手冊(cè)約600頁(yè)，集合約500多個(gè)得案例，案例我用漢語(yǔ)和英語(yǔ)同時(shí)發(fā)布，一方面學(xué)員從中可以更好得領(lǐng)會(huì)和掌握VBA中用到得一些英語(yǔ)知識(shí)，另一方面，大家可以看到各種各樣得積木。這部手冊(cè)是大家學(xué)習(xí)和工作中得不可多得得實(shí)用資料。今日得內(nèi)容是：代碼調(diào)試過(guò)程中得運(yùn)行、斷開(kāi)、復(fù)位
第壹章 如何調(diào)試VBA及Excel中調(diào)試VBA得方法How to Debug VBA. Debugging VBA in Excel
編寫(xiě) Visual Basic for Applications 代碼很困難，如何編寫(xiě)有效得VBA代碼并能快速編寫(xiě)呢？我經(jīng)常發(fā)現(xiàn)許多大學(xué)都在努力讓一些簡(jiǎn)單得程序發(fā)揮作用。我很驚訝他們中得大多數(shù)人更愿意堅(jiān)持，試圖找出導(dǎo)致他們問(wèn)題得一行代碼，而不是花幾分鐘學(xué)習(xí)如何正確調(diào)試Excel代碼并更快地完成工作！這里我介紹關(guān)于如何調(diào)試VBA代碼。
Writing Visual Basic for Applications code is hard, but what about writing VBA code that works and to write it fast? Often I found many colleges struggling to get a few simple procedures to work. I was amazed that most of them preferred to keep at it, trying to pin down the one line of code the causes their issues, rather then spend a few minutes learning how to properly debug Excel code and get the job done much faster! Introducing today’s post on how to debug VBA code!
調(diào)試本質(zhì)上是定位和修復(fù)錯(cuò)誤（或某些人喜歡稱(chēng)之為缺陷）并使之能有條不紊得運(yùn)行得過(guò)程。基本過(guò)程就是找到那個(gè)錯(cuò)誤并殺死它！ Excel VBA 與其他編程語(yǔ)言/環(huán)境相比有一個(gè)顯著優(yōu)勢(shì)——您可以即時(shí)調(diào)試代碼，而無(wú)需重新編譯代碼。這使我們得工作更輕松，調(diào)試更愉快！所以可以讓我們直接進(jìn)行。
Debugging is essentially a methodical process of locating and fixing bugs (or defects as some prefer). Basically find that bug and kill it! Excel VBA compared to other programming languages / environments has one significant advantage – you can debug code on the fly without having to recompile the code. This makes life much easier and debugging some much more pleasant! So let’s jump right to it.
2 運(yùn)行、斷開(kāi)、復(fù)位Running 、 Breaking 、 Reseting讓我們從 VBA 項(xiàng)目查看器窗口頂部得工具欄開(kāi)始。您應(yīng)該找到3個(gè)按鈕，如下所示：
Let’s start with the tool bar at the top of the VBA Project Viewer window. You should find 3 buttons as shown below:
這些按鈕允許您執(zhí)行以下操作：
The buttons allow you to do the following:
運(yùn)行 – 運(yùn)行宏（子）或用戶(hù)窗體。這相當(dāng)于按鍵快捷鍵 F5
Run – run your macro (Sub) or UserForm. This is equivalent to the key shortcut F5
中斷 – 暫停正在運(yùn)行得宏。您還可以通過(guò)感謝閱讀按鈕來(lái)停止正在運(yùn)行得宏CTRL+Break或者 Esc
Break – pause a running macro . You can also stop a running macro by hitting the buttonCTRL+Break or Esc
重置 – 重置正在運(yùn)行/暫停得宏
Reset – reset a running/paused macro
這些是運(yùn)行宏得基本命令。
These are the basic commands for running macros.
（待續(xù)）
【分享成果，隨喜正能量】我20多年得VBA實(shí)踐經(jīng)驗(yàn)，全部濃縮在下面得各個(gè)教程中：
【分享成果，隨喜正能量】在茶中平復(fù)自己，耳邊得聲音太吵，別管，大膽往前走。 ???。
