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!

This 4th edition is updated for Microsoft 365.

View first chapter and Table of Contents – FREE!

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!

About the author

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

Download the original source code for checking against your own work from our Downloads page