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 Programming

Workbook 7

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

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 2024 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 ebook Excel 2024 VBA Macro Editor.

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

Dr. Peter J. Scharpff RI

Related Content