03917nam 2200517 450 991079817230332120170919055132.01-119-22540-X1-119-22539-6(CKB)3710000000603987(EBL)4413734(MiAaPQ)EBC4413734(CaSebORM)9781119225386(EXLCZ)99371000000060398720160301h20162016 uy| 0engur|n|---|||||rdacontentrdamediardacarrierMastering VBA for Microsoft Office 2016 /Richard Mansfield3rd ed.Indianapolis, Indiana :Sybex, a Wiley brand,[2016]©20161 online resource (987 p.)Includes index.1-119-22538-8 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 MacroRecording 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 CombinationDeleting 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 MacroUsing 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 PreferencesChoosing and Laying Out the Editor WindowsIntegrated softwareBusinessComputer programsIntegrated software.BusinessComputer programs.005.2768Mansfield Richard1945-811371MiAaPQMiAaPQMiAaPQBOOK9910798172303321Mastering VBA for Microsoft Office 20163854953UNINA