Excel VBA in easy steps, 3rd edition 9781840788242

Excel VBA in easy steps, 3rd Edition

Written by In Easy Steps Team on . Posted in

In Easy Steps » Browse our Bookstore » Microsoft Office » Excel VBA in easy steps, 3rd Edition

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!

 

 

 

 

Special launch price £7.99 (RRP £11.99)

Pages: 192
Publication: March 2019

 

ebook (PDF) version also available

 

View or download first chapter and Table of Contents - FREE!

 

About the book

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!

 

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.

 

ISBN: 978-1-84078-824-2

 

Buy from Amazon.co.uk

Buy from Amazon.com

 

Let me know when this book is in stock

 

Quantity
Currently unavailable

Original Price: £11.99

Price: £7.99

You save: £4.00

Currently unavailable

LoadingUpdating...