Mastering VBA for Microsoft Office 2016

Bibliographic Details
Other Authors: Mansfield, Richard, 1945- author (author)
Format: eBook
Language:Inglés
Published: Indianapolis, Indiana : Sybex, a Wiley brand [2016]
Edition:3rd ed
Subjects:
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009849098506719
Table of Contents:
  • Cover ; Title Page ; Copyright ; Contents ; Introduction; Part 1 Recording Macros and Getting Started with VBA ; Chapter 1 Recording and Running Macros in the Office Applications ; What Is VBA and What Can You Do with It?
  • The Difference Between Visual Basic and Visual Basic for Applications Understanding Macro Basics ; Recording a Macro ; Displaying the Developer Tab on the Ribbon ; Planning the Macro ; Starting the Macro Recorder ; Naming the Macro ; Choosing How to Run a New Macro ; Running a Macro
  • Recording a Sample Word Macro Recording a Sample Excel Macro ; Creating a Personal Macro Workbook ; Recording the Macro ; Specifying How to Trigger an Existing Macro ; Assigning a Macro to a Quick Access Toolbar Button in Word ; Assigning a Macro to a Shortcut Key Combination
  • Deleting a Macro The Bottom Line ; Chapter 2 Getting Started with the Visual Basic Editor ; Opening the Visual Basic Editor ; Opening the Visual Basic Editor with a Macro Selected ; Opening the Visual Basic Editor Directly ; Navigating to a Macro
  • Using the Visual Basic Editor's Main Windows The Project Explorer ; The Object Browser ; The Code Window ; The Properties Window ; The Immediate Window ; Setting Properties for a Project ; Customizing the Visual Basic Editor ; Choosing Editor and View Preferences
  • Choosing and Laying Out the Editor Windows