Excel VBA in easy steps, 4th edition

Mike McGrath

Aug 2023 · In Easy Steps Limited

About this ebook

Get more out of Microsoft Excel and save time by learning Excel VBA (Visual Basic for Applications). Excel VBA in easy steps, 4th edition demonstrates VBA macro programming in a clear and concise manner, and will take your Excel proficiency to the next level:

Write your own Excel macros so that you can do a series of tasks at the click of a button.

Use VBA to automate repetitive tasks, and for functions and commands beyond Excel.

Create dialog boxes for user interactions and then define processes to handle user input.

Develop and share your Excel apps with colleagues – they’ll be impressed!

Whether you’re upgrading to Excel in Office 365 or new to macro programming, use this guide to master Excel VBA essentials – in easy steps!

Comes with free downloadable code to help you get started with Excel VBA right away!

  

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 

About the author

Mike McGrath now lives in South-east Europe, on the sun-kissed shores of the Aegean Sea. 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.