关于本站
人大经济论坛-经管之家：分享大学、考研、论文、会计、留学、数据、经济学、金融学、管理学、统计学、博弈论、统计年鉴、行业分析包括等相关资源。
经管之家是国内活跃的在线教育咨询平台!
经管之家新媒体交易平台
提供"微信号、微博、抖音、快手、头条、小红书、百家号、企鹅号、UC号、一点资讯"等虚拟账号交易，真正实现买卖双方的共赢。【请点击这里访问】
期刊
- 期刊库 | 马上cssci就要更新 ...
- 期刊库 | 【独家发布】《财 ...
- 期刊库 | 【独家发布】“我 ...
- 期刊库 | 【独家发布】“我 ...
- 期刊库 | 【独家发布】国家 ...
- 期刊库 | 请问Management S ...
- 期刊库 | 英文期刊库
- 核心期刊 | 歧路彷徨：核心期 ...
TOP热门关键词
扫码加入金融交流群 |
华尔街portfolio management方向必备技能！！
http://as.wiley.com/WileyCDA/WileyTitle/productCd-1118490371.html
Excel VBA Programming For Dummies, 3rd EditionJohn Walkenbach
ISBN: 978-1-118-49037-2
408 pages
February 2013
Description
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.
Table of Contents
Introduction 1
Part I: Getting Started with Excel VBA Programming 9
Chapter 1: What Is VBA? 11
Chapter 2: Jumping Right In 21
Part II: How VBA Works with Excel 31
Chapter 3: Working in the Visual Basic Editor 33
Chapter 4: Introducing the Excel Object Model 53
Chapter 5: VBA Sub and Function Procedures 67
Chapter 6: Using the Excel Macro Recorder 79
Part III: Programming Concepts 91
Chapter 7: Essential VBA Language Elements 93
Chapter 8: Working with Range Objects 115
Chapter 9: Using VBA and Worksheet Functions 129
Chapter 10: Controlling Program Flow and Making Decisions 143
Chapter 11: Automatic Procedures and Events 163
Chapter 12: Error-Handling Techniques 183
Chapter 13: Bug Extermination Techniques 197
Chapter 14: VBA Programming Examples 209
Part IV: Communicating with Your Users 231
Chapter 15: Simple Dialog Boxes 233
Chapter 16: UserForm Basics 249
Chapter 17: Using UserForm Controls 265
Chapter 18: UserForm Techniques and Tricks 283
Chapter 19: Accessing Your Macros through the User Interface 307
Part V: Putting It All Together 327
Chapter 20: Creating Worksheet Functions — and Living to Tell about It 329
Chapter 21: Creating Excel Add-Ins 347
Part VI: The Part of Tens 359
Chapter 22: Ten VBA Questions (and Answers) 361
Chapter 23: (Almost) Ten Excel Resources 365
Chapter 24: Ten VBA Do’s and Don’ts 369
Index 375
See Less
Author Information
John Walkenbach, known to his fans as Mr. Spreadsheet, has written some 50 books and around 300 articles on computer topics, predominantly Excel. He created the award-winning Power Utility Pak and several other versatile Excel add-ons. John maintains the Spreadsheet Page at http://spreadsheetpage.com.
免流量费下载资料----在经管之家app可以下载论坛上的所有资源，并且不额外收取下载高峰期的论坛币。
涵盖所有经管领域的优秀内容----覆盖经济、管理、金融投资、计量统计、数据分析、国贸、财会等专业的学习宝库，各类资料应有尽有。
来自五湖四海的经管达人----已经有上千万的经管人来到这里，你可以找到任何学科方向、有共同话题的朋友。
经管之家（原人大经济论坛），跨越高校的围墙，带你走进经管知识的新世界。
扫描下方二维码下载并注册APP
您可能感兴趣的文章
- 考研 | 求教-车险ABC条款
- 考研 | 财务指标选股方法
- 考研 | 跪求金融毕业论文选题！！！
- 考研 | 谢谢楼主分享
- 考研 | 李克特量表作为连续变量
- 考研 | 《财贸经济》发表经验
- 考研 | R语言的quantstrat包安装出错
- 考研 | 原创干货：财报分析实战案例（五 ...
本站推荐的文章
人气文章
本文标题：美国很流行的excel VBA programing入门，金融建模必学！！！
本文链接网址：https://bbs.pinggu.org/jg/kaoyankaobo_kaoyan_3109657_1.html
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性，不作出任何保证或承若；
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
