Categories Corporate
Professional eBook

Excel for Microsoft 365: VBA Programming

Workbook 7

63
Language:  English
This workbook shows you how to design and edit program code and forms in a number of practical examples. This way you can add extra functionality to spreadsheet program Excel for Microsoft 365.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Access this book on our eReader, no adverts inside the book
Description
Content
book.tabs.learning objectives

This workbook on programming in the Excel environment covers some of the more advanced applications and practical examples of VBA. The modules in a VBA project in Excel for Microsoft 365 contain instructions and elements that can make use of existing data, objects, and tools such as sheets, tables, charts, or buttons. This requires advanced techniques in programming and editing code in the VBA development environment. This was discussed extensively in the previous workbook Excel for Microsoft 365 VBA Macro Editor.

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. Programming techniques
    1. Introduction
    2. Functions
    3. Decision structures
    4. Loops
    5. Key capturing
    6. Variables and constants
    7. Error trapping
    8. Exercise
  3. Integrating code
    1. Introduction
    2. Start
    3. Add-in
  4. Case: An invoice model
    1. Introduction
    2. The invoice workbook
    3. The invoice form
    4. Creating the invoice
    5. Security
    6. User Interface
    7. Extra exercise
  5. Charts in VBA
    1. Introduction
    2. The workbook
    3. Use of the VBA-app
      • That’s it
      • Appendix

Gain knowledge on using VBA to automate tasks in Excel. Learn to create custom functions and handle errors in Excel using VBA. Discover methods to protect workbooks and manage user access with VBA in Excel.

About the Author
Dr.

Dr. Peter J. Scharpff RI