Excel VBA Programming For Dummies, 4/e (Paperback)
暫譯: Excel VBA 程式設計入門 (第4版)

John Walkenbach

買這商品的人也買了...

相關主題

商品描述

Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more. With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all! * Provides step-by-step instructions for creating VBA macros to maximize productivity * Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want * Fully updated for Excel 2016 * All sample programs, VBA code, and worksheets are available at dummies.com If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.

商品描述(中文翻譯)

提升您的數據分析和 Excel 程式設計技能。要將 Excel 提升到新的高度,您需要理解並實現 Visual Basic for Applications (VBA) 的強大功能。本書《Excel VBA 程式設計入門(第 4 版)》將介紹一系列新的 Excel 選項,從 Visual Basic 編輯器的最重要工具和操作開始。在書中,您將了解使用 Excel 程式設計的基本元素和概念,發現處理錯誤和消除漏洞的技巧,學習如何使用範圍物件、控制程式流程等更多內容。隨著 Microsoft Office 2016 的發布,Excel 的操作系統將會發生變化,而這本有趣的實用指南將使您比以往任何時候都更容易利用 Visual Basic for Applications 的力量,並在全球最受歡迎的電子表格工具上創建自定義應用程式和巨集。本書提供了友好的建議,介紹了開發自定義對話框、工具列和選單的最簡單方法,讓您能夠迅速創建符合您獨特需求的 Excel 應用程式!
* 提供逐步指導,幫助您創建 VBA 巨集以最大化生產力
* 通過演示如何自定義應用程式,使其看起來和運作方式符合您的需求,幫助提高效率
* 完全更新至 Excel 2016
* 所有範例程式、VBA 代碼和工作表均可在 dummies.com 獲得
如果您是一位初學者到中級的 VBA 程式設計師,想要快速掌握使用 Excel 應用程式創建自定義解決方案的技巧,《Excel VBA 程式設計入門(第 4 版)》將使這一切變得更簡單。