Kategorien Über uns
home.book.professional_ebook

Excel 2024: VBA Macro Editor

Workbook 6

62
Sprache :  English
In this workbook, learn to edit (recorded) macros and to create program code to add extra functionality to the popular spreadsheet program Excel 2024.
Professional Plus Mitgliedschaft 30 Tage gratis, danach $6.99/Monat
Beschreibung
Inhalt

With the programming language Visual Basic for Applications (VBA) you can develop (more) functionality of your own. It allows you to customise recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program with questions like ‘What is the initial value for the calculation?’, ‘Where is the data?’ or ‘What report do you want to print?’.

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 2024.

  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
Über den Autor/die Autorin
Dr.

Dr. Peter J. Scharpff RI