现在的位置: 首页英文图书, 软件>正文
Excel VBA Programming For Dummies, 3rd Edition
图书分类:英文图书, 软件 暂无评论 ⁄ 被围观 689 次阅读+

9781118490372 cover.inddBook 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.

From the Back Cover
Learn to:
Use the essential tools and operations for VBA
Get the most out of Excel’s macro recording feature
Handle errors and eliminate bugs in your code
Develop custom worksheet functions and user-oriented applications

Explore VBA programming and learn how to customize and automate many aspects of Excel

Maybe you’re eager to learn Excel programming. Maybe it’s your boss’s idea. Either way, this book will have you on your way to Excel programming perfection in no time! It’s a plain-English guide to what VBA is, how it works with Excel, essential programming concepts, and steps to creating some very cool dialog boxes, time-saving macros, Excel add-ins, and more.
VBA-speak — learn the language of VBA and steps for creating a program in Excel
Macro magic — automate common tasks, create custom buttons and commands, and develop new worksheet functions using VBA macros
Programming basics — work with range objects, control program flow, automate procedures and events, and exterminate bugs in your code
User communication — explore simple and custom dialog boxes and UserForm controls, tricks, and techniques
All together now — apply your skills to design user-oriented applications, create add-ins, and work with other Office applications

Open the book and find:
Some Excel history that’s good to know
All about VBA sub and function procedures
How you can get ahead by learning VBA
The difference between programming errors and runtime errors
Tips for finding and fixing bugs
How to customize Excel’s user interface
Ways to super-charge your formulas with custom worksheet functions
VBA dos and don’ts

Book Details
Paperback: 408 pages
Publisher: For Dummies; 3rd Edition (February 2013)
Language: English
ISBN-10: 1118490371
ISBN-13: 978-1118490372

标签:,

你可能喜欢

0 0 vote
Article Rating
Subscribe
提醒
0 评论
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x