Shows you how to get more out of Microsoft Excel. Use the Visual Basic for Applications (VBA) programming language thatโs built into Excel toย make itย much more powerful โย in easy steps!
Excel VBA in easy steps, 3rd 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. 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!
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.
Table of Contents
Getting started
Writing macros
Storing values
Performing operations
Making statements
Executing procedures
Employing functions 101
Recognizing events
Opening dialogs
Providing UserForm dialogs
Developing apps
Resources
Freely download the original source code for checking against your own work from our Downloads page