Mastering VBA for Microsoft Office 2016

Customize Office Applications Even Without Programming Experience Streamline tasks and be far more productive by using Visual Basic for Applications (VBA) to automate, customize, and extend Microsoft Office. Built into Office 2016, VBA is easily understood by even non-programmers, yet it's also powerful enough for IT professionals to create custom business applications for the enterprise. This clear, comprehensive guide covers it all-the basics for beginners and advanced techniques for experienced programmers. You'll learn how to use VBA to create macros, simplify Office tasks, and create custom solutions for Word, Excel, PowerPoint, Outlook, and Access. Coverage includes: Recording, writing, and running macros in Office 2016 Working with the powerful VBA Editor Mastering the essentials of VBA terminology Finding the objects, methods, and properties you need Making the most of the huge library of built-in functions Creating simple dialog boxes and complex forms Writing well-behaved, debugged, and secure code Managing cloud storage with OneDrive and Dropbox Customizing Word, Excel®, PowerPoint®, Outlook®, and Access® Communicating between applications Programming the Office 2016 ribbon Streamline and Automate Tasks with VBA for Office 2016 Create Custom Apps for Word, Excel, PowerPoint, Outlook, and Access Master VBA, from Basic to Advanced Programming Build Your Skills with Useful Real-World Examples and Projects