Log in

This website uses cookies

We use cookies to improve user experience. Choose which cookies you allow us to use. You can read more about our Cookie Policy in our privacy policy

See Cookies Details
Categories About Us
Professional eBook

Excel 2024: VBA Macro Editor

Workbook 6

by Dr. Peter J. Scharpff RI
62
Language :  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 subscription free for the first 30 days, then $6.99/mo
Description
Content

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
Write a review
About the Author
Dr.

Dr. Peter J. Scharpff RI