Maximize your Excel 2013 experience using VBA application development
The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition that covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.Offers an analysis of Excel application development and a complete introduction to VBAFeatures invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applicationsProvides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere elseIncludes a CD with templates and worksheets from the book
"Excel 2013 Power Programming with VBA" is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
This book is for intermediate excel users and it is better to use it as guidance for dealing with VBA programming. The author is so right when he suggests readers to skip around, picking up useful tidbits here and there. Indices of the book offer easy-to-find solutions for VBA programming problems. https://vebimo.wordpress.com/2017/09/...
This amazing book helped me to shift my career and work for two years as an Excel-VBA developer online. The book starts with basics in VBA and Excel. Then illustrates advanced techniques and methods to enhance the VBA code. Unlike other books and tutorials, the book do not invent the wheel and will use Excel tools and formulas when ever it is possible.
In my opinion, it is a "must read" for any one wants to work as a VBA developer.
This book has proved invaluable to me over the years as I have created macros inn Excel 2013. I cannot recommend this book enough. Each topic is explained clearly and with examples , soft copies which are made available by the author.