Excel VBA in easy steps: Illustrated using Excel in Microsoft 365

by Mike McGrath

Overview

Excel VBA in easy steps, 4th edition neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. This 4th edition is updated for Microsoft 365. Areas covered include:

 

Recording and editing Macros

Creating your own Macro programs

Coding with the VBA language

Responding to Worksheet events

Programming Excel procedures

Making "DataForms" for data editing

Producing "UserForms" for data entry

Displaying dynamic Charts

Sharing your Excel apps to impress your colleagues!

 

Use this guide to learn the key features constructively and get more out of Microsoft Excel – in easy steps!

Product Details

ISBN-13:	9781787910034
Publisher:	In Easy Steps Limited
Publication date:	10/13/2023
Series:	In Easy Steps
Edition description:	4th ed.
Pages:	192
Product dimensions:	7.20(w) x 8.80(h) x 0.40(d)
Age Range:	11 Years

About the Author

Mike gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world. His interests include coins of ancient Greece, dining-out with friends, and the ongoing evolution of the world wide web.

Table of Contents

1. Getting started
2. Writing macros
3. Storing values
4. Performing operations
5. Making statements
6. Executing procedures
7. Employing functions 101
8. Recognizing events
9. Opening dialogs
10. Providing UserForm dialogs
11. Developing apps