Excel VBA

A Step-By-Step Guide to Learn and Master Excel VBA Programming
Narrated by: William Bahl
Length: 1 hr and 33 mins
5.0 out of 5 stars (25 ratings)

Audible Premium Plus

$14.95 a month

1 audiobook of your choice.
Stream or download thousands of included titles.
$14.95 a month after 30 days. Cancel anytime.
Buy for $6.95

Buy for $6.95

Pay using card ending in
By confirming your purchase, you agree to Audible's Conditions of Use and Amazon's Privacy Notice. Taxes where applicable.

Publisher's Summary

Whether you have never created a program with Visual Basic Application or you're looking to learn some new tricks, then this audiobook is for you! Containing 15 chapters full of information, definitions, and step-by-step instructions to create your own programs, this audiobook will help you master VBA Programming.  

Our audiobook is powerful in that it provides you with everything you need to learn how to automate common spreadsheet tasks and also create the sophisticated management science applications needed in business nowadays. The benefits of our audiobook almost exceed your imagination. Some of the things you can gain from our audiobook include:

  • Chapters on Conditional Logic, String Functions, and Recording Macros
  • Step-by-step instructions for how to program Loops and Arrays
  • Two chapters on creating and programming User Forms
  • Instructions on how to write Subs and Functions
  • Written out sample codes for many of the programs you will learn how to create
  • How to diagnose and correct your own coding errors
  • A step-by-step process on how to connect the Visual Basic Editor with external data
  • And much more 

Visual Basic Application Programming in Excel is a hidden gem that will help you automate and control both basic and complex Excel functions. Following the steps in this audio book will help you access the inner workings of Excel spreadsheets and take your coding to the next level! 

Don’t waste your time working with an audio guide that’s only going to make an already complicated topic even more complicated. Buy this audiobook now to learn everything you need to know in no time!  

©2018 Hein Smith (P)2018 SJ PUBLISHING

What listeners say about Excel VBA

Average Customer Ratings
Overall
  • 5 out of 5 stars
  • 5 Stars
    24
  • 4 Stars
    1
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Performance
  • 5 out of 5 stars
  • 5 Stars
    24
  • 4 Stars
    1
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Story
  • 5 out of 5 stars
  • 5 Stars
    24
  • 4 Stars
    1
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Reviews - Please select the tabs below to change the source of reviews.

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Must-have book

A must-have book for those who want to learn Excel VBA. This book is designed for busy professionals who need to take their Excel abilities to the next level. The author offers in detail, concise, and easy to understand. Throughout this guide, I learned the basics of VBA as promised. It contains useful insights in some of the key elements with suggestions on how to explore further when using VBA on your own. The book is easy to understand and you will get results fast. The examples are very useful. A great course to anyone looking to expand on excel VBA. Highly recommended!

7 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Help you improve with VBA

Do you want to design and code an Excel VBA Application like a pro? Then this book is for you. The author has shown many tips and tricks for getting to the most out of Excel VBA. He provides everything you need to know to be able to use VBA to workflow, save time, and automate your current Excel projects. Use these tips and tricks to improve your efficiency. This book is suited for beginners, intermediate, and advanced programmers. In part one, you will learn about VBA Overview, VBA Programming Variables, Conditional Logic, String and String Functions, and String and String Functions Continued. In part 2, you'll know about Programming Loops, Programming Arrays, Subs and Functions, Writing and Recording Macros, and Excel Objects. In part 3- for advanced, Excel Events, VBA Error Types, Excel VBA and User Forms, and Connect with Externa lData With the use of this guide, I am sure you will discover some that you have not seen before and others that you have been using incorrectly. It's a really comprehensive book covering many aspects of VBA. Consider this guide to become more productive using Excel at work, school, and home.

5 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Quite useful

I already knew quite a bit about working with Excel functions coming in, but was intimidated by learning VBA. The main reason for taking the course was to learn VBA, but I did pick up some helpful tips in the earlier sections too. Hein made it really easy to learn, and it's set up in a way that provides practical uses. The VBA section has been very helpful and has given me lots of ideas on how to improve my spreadsheets, and has given me the confidence to give it a go. The macro section has also been very helpful. I would definitely recommend the course to anyone who isn't familiar with Excel, but even if you are, the later parts of the course will teach you something.

4 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

An amazing guide!

An amazing guide! The book has absolutely transformed my career. I literally couldn't even do a sum formula. But through this, I was able to understand and apply the things contained in it. I believe it’s definitely worth the purchase. I absolutely love all the information given by the author.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Ton of info

I've learned a ton from this book that covered a range of topics by building an application from scratch. I love the trick to update the dictionary value. I'll definitely be utilizing enum and the settings class. I used to use the Application.screenupdating = False, Application. The calculation, etc and reset them to True at the end. Class modules are still foreign to me, but I'll first utilize your template! Thank you again!

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Great author

Hi Mr. Smith! Like always, great guidebook. I love the extras that you keep throwing in along the way. This time it was the simple class module for managing Excel functionality like calculation and events that caught my eye. I plan to use it and give you full credit in all my applications. I am rebuilding an old application that was created before I found your site and picked up the VBA Handbook, this little class will make a solid addition to unwinding that mess of code. Highly recommended!

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Thankful

Trying to figure out Excel VBA as a complete novice was very confusing. This book is easy to follow and understand with some actual examples of applications that helped me grasp the concepts. When I listened to this book, I can say that I feel like a pro now. I was thankful and blessed to have this.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Great content

After I listened to this book, I would say that it is not a waste of time for listeners who already know the basics. It contains excellent and handy tips in creating Excel Worksheets. The contents of the book itself are informative and helpful. I absolutely love all the information that the book has to offer.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Easy to follow instructions

Very practical, easy to follow instructions and a good book to have if you work with Excel. I think this is better than any class we have taken. I have learned many helpful tips and tricks from this book. I found the techniques very easy to follow. I recommend this book to those who want to learn or enhance their skills.

2 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

An excellent guide to follow

An excellent guide to follow. If you want to learn more about how you can create customized solutions using Excel, grab a copy of this book now. It will show you the step-by-step instructions that will help you create macros in Excel to maximize your productivity.

2 people found this helpful

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Tristan
  • Tristan
  • 07-08-20

Insightful

This book didn't disappoint me in any way. It helped me understand the principles of VBA and how to approach this programming language. I learned quite a lot from your Excel tricks to achieve a task. The book covers a wide variety of great tips and also provides some of the nuances for context. Hein Smith did a great job of explaining the subjects in a very simple way. He provides tips and tricks on how to overcome common problems. He also laid out the most common mistakes in executing VBA Excel. A comprehensive guide with a clear explanation of the VBA language and macros in Excel. I do recommend this guide to anyone who would like to start their journey to start building excel programs. I was so glad to found it. Lots of thanks to the author.

6 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Lorelie M.
  • Lorelie M.
  • 07-10-20

A great informative book

This book was amazing! The author will take you step-by-step through listening to this audiobook. He provides everything you need to know to be able to use VBA to workflow, save time and automate your current Excel projects. With this guidebook, I learned to manage large quantities of data, undo a VBA subroutine, and change Excel to PDF, among others. It's really comprehensive book covering many aspects of VBA. Using this function of Excel, you will be able to create applications customized for to your needs such as automatically analyzing a chart of data, using formulas to collect data, or creating dialogue boxes and customized user forms. If you want to learn more about VBA, don't miss the chance to grab this book. Very well thought out and structured guide.

5 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Sol Lyn Sand
  • Sol Lyn Sand
  • 07-11-20

Comprehensive book

Of all the books I read and listened to, I would say that this is one of the most comprehensive guides to have. Using this function of Excel, you will be able to create applications customized for your needs such as automatically analyzing a chart of data, using formulas to collect data, or creating dialogue boxes and customized user forms.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Ellen Kelly
  • Ellen Kelly
  • 07-09-20

An excellent guide to follow

An excellent guide to follow. If you want to learn more about how you can create customized solutions using Excel, grab a copy of this book now. It will show you the step-by-step instructions that will help you create macros in Excel to maximize your productivity.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Sebastian
  • Sebastian
  • 07-09-20

Love it

Do you want to design and code an Excel VBA Application like a pro? The author has shown many tips and tricks for getting to the most out of Excel VBA. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. Consider this guide to become more productive using Excel at work, school, and home.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Chandrea
  • Chandrea
  • 07-07-20

Glad to have it

I've been struggling with Excel and don't know how to fix it. This VBA Excel book provides a step-by-step guide to learn and master it. It introduces numerous Excel options starting right from the different tools and operations that you can perform using Visual Basic. I was glad that I found this guide and able to do macros.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for John Sy
  • John Sy
  • 07-15-20

Powerful audio guide

I already have an idea about excel so the introduction was just a run through but the author was excellent for the new students. Easy to understand. Learned a lot as I went deeper into the advanced level.

2 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Vina M.
  • Vina M.
  • 07-14-20

Designed for novices to busy professionals

This is a must-have book for those who want to learn Excel VBA. It's designed for busy professionals who need to take their Excel abilities to the next level. Throughout this guide, I learned the basics of VBA as promised. It contains useful insights in some of the key elements with suggestions on how to explore further when using VBA on your own. The book is easy to understand and you will get results fast. The examples are very useful. A great course to anyone looking to expand on excel VBA. Highly recommended!

2 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Evengeline Eve
  • Evengeline Eve
  • 07-13-20

Very practical

Very practical, easy to follow instructions and a good book to have if you work with Excel. I think this is better than any class we have taken. I have learned many helpful tips and tricks from this book. I found the techniques very easy to follow. I recommend this book to those who want to learn or enhance their skills.

2 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Luise Wood
  • Luise Wood
  • 07-13-20

Very useful

Through this guidebook, you'll know the various Excel options starting right from the different tools and operations that you can perform using Visual Basic. Along this course, you'll also discover different techniques to help you remove bugs and handling errors.

2 people found this helpful