VBA & Macros for Microsoft Excel 2016


November 2015

VBA & Macros for Microsoft Excel 2016

Automate your Reports with Excel VBA

If you are proficient with Excel but have never used VBA, this book will bring you up the VBA Learning Curve

Bill Jelen, MrExcel
Buy Now »

category: VBA, Programming
covers: Microsoft 365, Excel 2016

Product Details
  • 640 Pages
  • Publisher: Que Publishing
  • ISBN: 978-7897-5585-8

Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it… capture data from anywhere, and use it anywhere... automate Excel 2016’s best new features.

About MrExcel Library

Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

  • Dramatically increase your productivity—saving you 50 hours a year or more
  • Present proven, creative strategies for solving real-world problems
  • Show you how to get great results, no matter how much data you have
  • Help you avoid critical mistakes that even experienced users make
  • Introduction
  • Unleash the Power of Excel with VBA
  • This Sounds Like BASIC, So Why Doesn't It Look Familiar?
  • Referring to Ranges
  • Looping and Flow Control
  • R1C1-Style Formulas
  • Create and Manipulate Names in VBA
  • Event Programming
  • Arrays
  • Creating Classes, Records, and Collections
  • Userforms[md]An Introduction
  • Data Mining with Advanced Filter
  • Using VBA to Create Pivot Tables
  • Excel Power-Sample Macros
  • Sample User-Defined Functions
  • Creating Charts
  • Data Visualizations and Conditional Formatting
  • Dashboarding with Sparklines
  • Reading from and Writing to the Web
  • Text File Processing
  • Automating Word
  • Using Access as a Back End to Enhance Multi-User Access to Data
  • Advanced Userform Techniques
  • Windows Application Programming Interface (API)
  • Handling Errors
  • Customizing the Ribbon to Run Macros
  • Creating Add-Ins
  • Creating Apps with Java Script
  • What's New in Excel 2016 and What's Changed

VBA on a Mac

In VBA & Macros for Microsoft Excel, we mentioned that we would post a list of gotchas to watch out for when you are using VBA on a Mac. Here is the list:

  • Application.ScreenUpdating doesn't work
  • Usersform - don't recommend using big labels. We have no control over the fonts, so it can cause a problem. Actually, the more we can avoid UserForms, the better.
  • ActiveX controls - do not work; have to use Form Controls.
  • No dlls. That means if you want to let the user lookup a file, you have to do it the hard way.
  • Functions: some VB functions may not be available - like Split, Replace.
  • Database files: not allowed
  • Best rule: Program as if the user has Excel 97
  • For more suggestions: http://www.rondebruin.nl/mac.htm#FileFormat

Where to Buy

InformIT

eBook / Print book from InformIT

Amazon

Print book from Amazon.


Other Editions


VBA and Macros for Microsoft Excel 2007

August 2007

As the macro language for Microsoft Excel, Visual Basic for Applications enables you to achieve tremendous efficiencies in your day-to-day use of Excel. Stop producing those manual reports! The solution is to automate those manual processes in Excel using Visual Basic for Applications (VBA). Every copy of Excel shipped since 1993 includes VBA lurking behind the cells of the worksheet.


VBA and Macros for Microsoft Excel

May 2004

In this book, Jelen and Syrstad reveal exactly why the macro recorder fails. They will teach you how to understand recorded code so that you can quickly edit and improve the 10% of recorded code that is preventing your applications from running flawlessly every day.


Microsoft Excel 2019 VBA and Macros

November 2018

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.


VBA and Macros: Microsoft Excel 2010

July 2010

Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques needed to automate virtually any Excel task and customize virtually any Excel report or business solution.


VBA and Macros Microsoft Excel 2013

February 2013

Use Excel 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You’ll discover macro techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful and useful.


Related Products


2500 Excel VBA Examples

April 2006

The 2500 Excel VBA Examples CD is an amazing resource. A joint project between Germany's Hans W. Herber, Tom Urtis, and MrExcel, the CD is the most comprehensive reference on Excel VBA available today.


Office VBA Macros You Can Use Today

January 2006

Learn best-practice coding examples for each core Office product.


LiveLessons: Excel VBA and Macros with MrExcel

April 2009

The Excel VBA and Macros DVD-ROM with MrExcel delivers the power of the best classroom training with over 7 hours of instruction covering 50 lessons. Each lesson begins with well-defined learning objectives and ends with comprehensive summaries.