Excel VBA: for Non-Programmers (Programming in Everyday Language) (Volume 1)

Microsoft Excel has, over the years, become the greatest software in the field of electronic worksheets. Its strength is that it meets the demands of huge numbers of users worldwide. Nonetheless - despite the advancement and expanding use of this software - there is ever-increasing demand from the end users; much of which can only be solved by VBA programming (Visual Basic for Applications). Therefore, “Excel VBA – In Everyday Language” was written in order to provide a response to the growing demand for the advanced capabilities of Microsoft Excel. This book was written: • For the “non-programmers” among us who have to create the same reports in Microsoft Excel time and again, and would like to automate the process. • For people who wish to develop forms, screens and “machines” for data management within their organization. • For individuals who wish to turn Microsoft Excel into a powerful tool in their daily work. During the writing process I tried to visualize Microsoft Excel software and the VB editor through the eyes of the end users; people who may not have programming background, but aspire to reap the utmost from the program. For this reason the book, based on many years' of experience in programming and training, has been written in everyday language, using as few technical terms as possible, to make for easy reading. My goal, when writing this book, was to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training. For this purpose there are files of exercises accompanying the book. These may be downloaded from this link. The exercise files are in .xls format, allowing the end users to use either the “Ribbon Versions” (2007 and higher) or other older versions of Microsoft Excel. This new edition has undergone extensive processing and addresses Microsoft Excel 2010/2013 users, along with explanations for anyone using the older versions (2003 and 2007). Therefore, wherever there is a significant difference between Excel 2010/2013 and the old versions, explanations are provided in full. While reading the book and using the practice files, you will know to: • Add the Developer Tap • Change Excel's security, Including trusted locations • Enter the VBE (Visual Basic Editor) • Change the VBE structure • Record an absolute macro • Record a relative macro • Improve your recorded macro • Apply to ranges (Cells, ranges, columns, rows, sheets, offset) • Use Variables • Use the 'With' command • Manipulate strings • Calculate Date and Time • Interact with the user (Msgbox and Inputbox) • Use conditions (IF) • Loop through data (Do loops, For loops) • Create your own functions (UDF) • Create an Event macro • Handle Errors You will also learn some cool tips and tricks, and get some useful codes

多年來，Microsoft Excel已成為電子工作表領域中最強大的軟體。它的優勢在於滿足全球眾多使用者的需求。儘管這款軟體不斷進步並被廣泛使用，但終端使用者對其的需求卻不斷增加，其中許多需求只能通過VBA程式設計（Visual Basic for Applications）來解決。因此，《Excel VBA – In Everyday Language》一書應運而生，旨在回應對Microsoft Excel高級功能日益增長的需求。本書的寫作目的如下：
• 面向我們中的「非程式設計師」，他們需要一遍又一遍地在Microsoft Excel中創建相同的報告，並希望自動化這個過程。
• 面向希望在組織內部開發表單、屏幕和「機器」進行數據管理的人士。
• 面向希望將Microsoft Excel轉變為他們日常工作中強大工具的個人。
在寫作過程中，我試圖從終端使用者的角度來想像Microsoft Excel軟體和VB編輯器，這些人可能沒有程式設計背景，但渴望從該程式中獲得最大的效益。因此，本書基於多年的程式設計和培訓經驗，以盡可能少的技術術語，用日常語言撰寫，以便讀者輕鬆閱讀。我在撰寫本書時的目標是傳達VBA語言的主要原則，讓初學者能夠在不需要個別培訓的情況下學習。為此，本書附帶了練習檔案，可以從以下鏈接下載。練習檔案的格式為.xls，使終端使用者可以使用「功能區版本」（2007及更高版本）或其他舊版本的Microsoft Excel。本新版經過了廣泛的處理，針對Microsoft Excel 2010/2013用戶進行了說明，同時也對使用舊版本（2003和2007）的用戶進行了解釋。因此，在Excel 2010/2013和舊版本之間存在顯著差異的地方，提供了詳細的解釋。在閱讀本書並使用練習檔案時，您將學會以下技能：
• 添加開發人員選項卡
• 更改Excel的安全性，包括信任位置
• 進入VBE（Visual Basic Editor）
• 更改VBE結構
• 錄製絕對宏
• 錄製相對宏
• 改進錄製的宏
• 應用於範圍（單元格、範圍、列、行、工作表、偏移）
• 使用變數
• 使用"With"命令
• 操作字符串
• 計算日期和時間
• 與用戶互動（Msgbox和Inputbox）
• 使用條件（IF）
• 循環遍歷數據（Do循環、For循環）
• 創建自己的函數（UDF）
• 創建事件宏
• 處理錯誤
您還將學習一些很酷的技巧和訣竅，並獲得一些有用的程式碼。