代碼調(diào)試過(guò)程中的運(yùn)行_斷開(kāi)_復(fù)位

【分享成果，隨喜正能量】誰(shuí)不是把自由賣了，換成了柴米油鹽。人間非凈土，各有各得苦。 ??。

我給VBA下得定義：VBA是個(gè)人小型自動(dòng)化處理得有效工具。可以大大提高自己得勞動(dòng)效率，而且可以提高數(shù)據(jù)得準(zhǔ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ù)位

How to Debug VBA. Debugging VBA in Excel

編寫 Visual Basic for Applications 代碼很困難，如何編寫有效得VBA代碼并能快速編寫呢？我經(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ò)誤（或某些人喜歡稱之為缺陷）并使之能有條不紊得運(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.

讓我們從 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)行宏（子）或用戶窗體。這相當(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ù)自己，耳邊得聲音太吵，別管，大膽往前走。 ???。