Excel VBA Programming For Dummies, 3/e (Paperback)

John Walkenbach

  • 出版商: Hungry Minds
  • 出版日期: 2013-02-25
  • 定價: $1,050
  • 售價: 5.0$525
  • 語言: 英文
  • 頁數: 408
  • 裝訂: Paperback
  • ISBN: 1118490371
  • ISBN-13: 9781118490372
  • 相關分類: Excel
  • 立即出貨(限量) (庫存=1)

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

相關主題

商品描述

Take control of your spreadsheets and use VBA to create your own custom Excel applications

Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.

  • Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor
  • Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions
  • Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more
  • Zeroes in on creating custom dialog boxes, toolbars, and menus

Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition.

商品描述(中文翻譯)

掌握你的試算表,使用VBA創建自己的自定義Excel應用程式
作者和Excel專家約翰·沃肯巴赫(John Walkenbach),被他的忠實粉絲稱為“試算表先生”,通過使用Visual Basic for Applications(VBA)創建自己的自定義試算表解決方案,引導您將Excel技能提升到更高水平。這本暢銷書的更新版向您展示如何使用VBA,編寫宏,自定義您的Excel應用程式以符合您的要求,避免錯誤等等。

介紹了各種新的Excel 2013選項,從Visual Basic編輯器的最重要工具和操作開始
概述了使用Excel進行編程的基本元素和概念,包括使用VBA自定義應用程式和自動化功能
分享處理錯誤、調試、處理範圍對象、控制流程等技巧
專注於創建自定義對話框、工具欄和菜單

通過《Excel VBA Programming For Dummies, 3rd Edition》為您的試算表增添個人風格,以您想要的方式呈現數據。