Categories Corporate
Professional eBook

Excel for Microsoft 365: VBA Macro Editor

Workbook 6

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 for Microsoft 365.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Kirja ei sisällä mainoksia
Description
Content
book.tabs.learning objectives

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 for Microsoft 365.

About the Author

Peter Scharpff is oorspronkelijk afkomstig uit de computer-linguïstische hoek. Zijn wetenschappelijke focus lag op de interactie tussen mens en machine, vooral op de spraak- en taaltechnische kant daarvan. Behalve het ontwikkelen van materiaal voor trainingsdoeleinden op het gebied van kantoorautomatisering, heeft hij ook vele publicaties op zijn naam staan over algemenere onderwerpen als digitale veiligheid, privacy, hardware, programmeren, webdesign, telewerken, sociale netwerken, en dergelijke.

---

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 created many publications on more general topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, 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

Use Visual Basic for Applications to record, edit, and write custom scripts. Create user forms and controls within Excel using VBA to enhance user interaction. Apply naming conventions and explore the object browser to maintain code clarity.

About the Author
Dr.

Dr. Peter J. Scharpff RI