Cargando…
Microsoft Excel 2016 Programming by Example.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Bloomfield :
Mercury Learning & Information,
2016.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Title Page; Copyright; Dedication; Contents; Acknowledgments; Introduction; Part I: Excel VBA Primer; Chapter 1: Excel Macros
- A Quick Start in Excel VBA Programming; Macros and VBA; Excel Macro-Enabled File Formats; Macro Security Settings; Enabling the Developer Tab in Excel; Hands-On 1.1. Setting Up Excel for Macro Development; Using the Built-In Macro Recorder; Planning a Macro; Hands-On 1.2. Getting Things Ready for Macro Recording; Recording a Macro; Hands-On 1.3. Inserting and Naming a Worksheet (Macro Task 1).
- Hands-On 1.4. Inserting Column Headings and Applying Formatting (Macro Task 2)Hands-On 1.5. Entering Employee Data (Macro Task 3); Hands-On 1.6. Entering Formulas to Fill in Employee First Name (Macro Task 4); Hands-On 1.7. Entering Formulas to Fill in Employee Last Name (Macro Task 5); Hands-On 1.8. Entering Formulas to Calculate Employee Total Wages (Macro Task 6); Hands-On 1.9. Applying Table Format (Macro Task 7); Editing Recorded Macros; Hands-On 1.10. Examining the Macro Code; Macro Comments; Hands-On 1.11. Adding Comments to the Macro Code; Cleaning Up the Macro Code.
- Hands-On 1.12. Cleaning Up the Macro CodeRunning a Macro; Hands-On 1.13. Running a Macro Using the Macro Dialog Box; Testing and Debugging a Macro; Hands-On 1.14. Running a Macro from the VBE Screen; Saving and Renaming a Macro; Hands-On 1.15. Saving Macros and Running Macros from Another Workbook; Printing Macro Code; Hands-On 1.16. Printing Macro Code; Improving Your Recorded Macros; Hands-On 1.17. Adding Visual Basic Statements to the Recorded Macro Code; Creating a Master Macro; Hands-On 1.18. Creating a Master Macro Procedure; Various Methods of Running Macros.
- Running the Macro Using a Keyboard ShortcutHands-On 1.19. Assigning a Macro to a Keyboard Shortcut; Running the Macro from the Quick Access Toolbar; Hands-On 1.20. Running a Macro from the Quick Access Toolbar; Running the Macro from a Worksheet Button; Hands-On 1.21. Running a Macro from a Button Placed on a Worksheet; Summary; Chapter 2: Excel Programming Environment
- A Quick Overview of Its Tools and Features; Understanding the Project Explorer Window; Understanding the Properties Window; Understanding the Code Window; Setting the VBE Options; Syntax and Programming Assistance.
- List Properties/MethodsList Constants; Parameter Info; Quick Info; Complete Word; Indent/Outdent; Hands-On 2.1. Indenting/Outdenting Visual Basic Code; Comment Block/Uncomment Block; Using the Object Browser; Hands-On 2.2. Writing a VBA Procedure to Move a Text Box on the Worksheet; Hands-On 2.3. Writing a VBA Procedure to Move a Circle on the Worksheet; Locating Procedures with the Object Browser; Hands-On 2.4. Using Object Browser to Locate VBA Procedures; Using the VBA Object Library; Hands-On 2.5. Writing a VBA Procedure to Create a Folder in Windows; Using the Immediate Window.