A NEW book, direct from the publisher.

192 pages
By Mike McGrath
ISBN: 9781787910034
(RRP £12.99)

Get more out of Microsoft Excel and save time by learning Excel VBA (Visual Basic for Applications). Excel VBA in easy steps, 4^th 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