Connexion Testez gratuitement

Follow us

Bienvenue sur Bookboon

Afin de vous proposer nos services, nous nous reposons sur des cookies. Ceux-ci sont essentiels pour accéder à nos fonctionnalités.

Lire les détails relatifs aux cookies
Catégories Corporatif
Livre électronique professionnel

Excel 2021: VBA Macro Editor

Workbook 6

par Dr. Peter J. Scharpff RI
62
Langue:  English
In this workbook, learn to edit (recorded) macros, and to create program code to add extra functionality to the popular spreadsheet program Excel 2021.
Abonnement Pro Plus gratuit pour les 30 premiers jours, puis $6.99/mois
Lisez ce livre avec notre eReader, sans pubs
Description
Contenu
book.tabs.learning objectives

In this workbook we will discuss VBA and the environment where instructions (in macros) can be edited. The follow-up book VBA Programming then contains some more advanced application options and practical examples of VBA within Excel 2021.

About the Author

Peter Scharpff originates from the scientific computer-linguistic field focussing on the interaction between man and machine, especially on speech and language engineering. After that he started to develop training material for office automation. In the last few decades he has also produced many publications on topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, drawing, audio, video and photo editing and the like.

  • About the author
  1. Introduction
    1. Design
    2. Notation
    3. Software
  2. Development environment
    1. Introduction
    2. Developer tab
  3. Macros
    1. Introduction
    2. Recording a macro
    3. Running a macro
    4. Relative Reference
    5. Exercise
  4. Programming
    1. Introduction
    2. Creating Programs
    3. Objects
    4. Program structures
    5. Variables
    6. Comments
  5. The VBA Editor
    1. Introduction
    2. What’s in the window?
    3. Working windows
  6. Generating code
    1. Introduction
    2. Recording
    3. Editing Code
    4. Forms
  7. Overview
    1. Introduction
    2. Hungarian notation
    3. Immediate window
    4. Object Browser
    5. Exercise
  • That’s it
  • Appendix

Learn how to use more advanced features in Excel. Know how to create user-friendly forms in Excel.

Ecrire un commentaire
A propos de l'auteur
Dr.

Dr. Peter J. Scharpff RI

Découvrir l'auteur
Contenu associé