Excel VBA: Top Tips, Tricks, Timesavers, and Common Mistakes in VBA Programming

Narrated by: William Bahl
Length: 1 hr and 16 mins
5 out of 5 stars (28 ratings)

$14.95/month after 30 days. Cancel anytime.

OR
In Cart

Publisher's Summary

Do you use Excel VBA often? Have you been looking for a way to up your Excel skills? Well, look no further. This audiobook is exactly what you need! 

People get caught up in the technicality of Excel VBA and waste time. This audiobook will help prevent that.

Throughout this audiobook, you will learn the following:

Tips, tricks, and time-savers such as:

  • How to use immediate window
  • How to bypass workbook_open
  • How to choose every third row
  • How to pick 500 cells or rows with just one click
  • How to use InStr function
  • How to change Excel to a PDF
  • How to undo a VBA subroutine
  • How to determine if you have a range that is held inside another range

Most common mistakes such as:

  • Qualifying your range references
  • Using .Select/ .Activate
  • ActiveWorkbook versus ThisWorkbook
  • Using variable definition
  • How to delete rows or columns in a loop properly
  • And much more!

When it comes to Excel VBA, you want to be sure of what you're doing and confident in how it will turn out. Don't continue stumbling through - get this audiobook today and improve your Excel skills!

©2018 Hein Smith (P)2018 Hein Smith
What members say
Average Customer Ratings
Overall
  • 5 out of 5 stars
  • 5 Stars
    28
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Performance
  • 5 out of 5 stars
  • 5 Stars
    28
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Story
  • 5 out of 5 stars
  • 5 Stars
    28
  • 4 Stars
    0
  • 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

Excellent guide to follow

This book was exactly what I needed. I have programming experience so this primer was perfect. The real-life examples of problems and solutions where really fantastic as most of them I'm facing in my current projects. A good introduction and easy to understand.

I can say that Mr. Smith has the ability to explain how everything works, focusing on the most important parts, so that you not only know how to do something but also why you do it that way. This book is excellent and very professional. The content is clearly explained, well-structured, and covers many things.

I do suggest this guide to anyone interested in learning Excel VBA. Don't miss this guide even if you're a novice. Get yours as well.

3 people found this helpful

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

Well-detailed guidebook

I would say that this is a must-have book if you want to learn Excel VBA. This book is packed with some advice on the different techniques that you can use to develop custom toolbars, menus, and dialog boxes. You can, therefore, create an application in Excel that will fit your needs.

3 people found this helpful

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

Pretty cool

Thank you very much, Sir Smith, for sharing this book with us. I'm from the commerce field and I want to learn more about Excel VBA and I found this guide very useful. I was thankful because I learned from the mistakes I've done. A solid five-star.

2 people found this helpful

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

Loved Excel VBA

Terrific lesson. I have built several Excel applications during the past few years and thought I had good techniques and habits, but this lesson identified things I should do to make them better. I appreciate the instruction very much.

2 people found this helpful

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

Awesome

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

2 people found this helpful

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

Fabulous

This audiobook is great for programmers of all levels. Whether you're new to Excel or totally a novice, Mr. Hein Smith provides different techniques and tips to master this course.

In it, you'll learn how to use the immediate window, how bypass to workbook_open, how to change Excel to a PDF, how to undo a VBA subroutine, and how to determine if you have a range that is held inside another range, among others.

If you are looking forward to learning Advance VBA skills just go for this course and you will not regret it.

2 people found this helpful

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

Good pace to adjust

This guidebook offers tips, tricks and practical examples with all the code and sample templates you need to start your journey from humble data analyst to Excel programming pro. Take your Excel skills to the next level by harnessing the power of the VBA language. Hurry up! Get it now!

2 people found this helpful

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

Comprehensive reference

This comprehensive resource will help you automate data processes and develop full-featured Excel programs. This one-of-a-kind resource that presents everything you need to develop both large and small Excel applications.

2 people found this helpful

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

Refreshed me

The book refreshed what I knew but also showed may things I didn't know before. It was explained in an easy and understandable manner. I can say that this is great for those who already have an idea in Excel. It is also a good starting point for the first-timers.

2 people found this helpful

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

A very useful guide

If you already have reasonable knowledge about excel but you want to learn more that gives you the edge, then this book is perfect for you. The chapters aren’t too long but cover a wide range of topics. A great resource to apply and refer to when you need it.

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 Linda Price
  • Linda Price
  • 03-13-20

Amazing guidebook

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.

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 Barbara Bennet
  • Barbara Bennet
  • 03-13-20

Great book

Excel VBA: Top Tips, Tricks, Timesavers, and Common Mistakes in VBA Programming by Mr. Hein Smith will let you learn the essential information on how to properly use Excel VBA. After listening to it, I now feel confident that to apply things I learned as I already have a better understanding of VBA.

Mr. Smith explains the topics very clearly. He provides amazing tips, tricks, timesavers, and mistakes to obtain practical fluency in Visual Basic for Applications. I liked the course a lot and it was very informative.

This book is for you whether your goal is to use Excel VBA in your day job to enhance your productivity or you would like to use your VBA Programming skills in another profession. A wonderful guide indeed.

4 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 Butler John
  • Butler John
  • 03-16-20

Explaines everything

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

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Franky
  • Franky
  • 03-16-20

Treasure thing

This book is nothing but a treasure to be mined. If you already have a basic knowledge of Excel somewhere in your brain, this will be adequate. Simple, easy to understand.

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 Mark B
  • Mark B
  • 03-16-20

Refreshing

The book refreshed what I knew but also showed may things I didn't know before. It was explained in an easy and understandable manner. I can say that this is great for those who already have an idea in Excel. It is also a good starting point for the first-timers.

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 Jeffrey
  • Jeffrey
  • 03-15-20

Found it helpful

I found this book very helpful. It provides a good foundation and understanding of VBA so you can move on to further hone your skills. Good introduction, clear and easy to understand instructions. Well worth the purchase!

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 Larry Peterson
  • Larry Peterson
  • 03-15-20

5 stars

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

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 Jose Long
  • Jose Long
  • 03-14-20

Fabulous audible

This book is for you whether your goal is to use Excel VBA in your day job to enhance your productivity or you would like to use your VBA Programming skills in another profession. Good introduction and easy to understand.

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 Margaret Colines
  • Margaret Colines
  • 03-14-20

Easy to follow along

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.

If you want to learn more about VBA, don't miss the chance to grab this book. Very well thought out and structured guide.

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 Susan Henderson
  • Susan Henderson
  • 03-14-20

Pertinent and concise

The information in this book was useful and allowed me to better understand the principles of working with Excel VBA. A wonderful book indeed.

2 people found this helpful