Excel VBA in easy steps, 3rd edition

by Mike Mcgrath

Overview

Excel VBA in easy steps 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. 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!

Whether you're upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel – in easy steps!

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

Product Details

BN ID:	2940161264690
Publisher:	In Easy Steps Limited
Publication date:	04/17/2019
Sold by:	Barnes & Noble
Format:	eBook
File size:	20 MB
Note:	This product may take a few minutes to download.

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.