Excel VBA Introduction Part 3 – What to do When Things Go Wrong (Errors and Debugging)




About this tutorial:

Video duration: 18:20
If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos you can click this link to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here

By Andrew Gould

– If you’ve written at least one subroutine in VBA you’ll probably already be familiar with the feeling of frustration when things don’t work! This video teaches you about the different types of error that…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

35 thoughts on “Excel VBA Introduction Part 3 – What to do When Things Go Wrong (Errors and Debugging)

    Van Zyl Spengler

    (September 21, 2017 - 1:00 pm)

    THANK YOU THANK YOU THANK YOU! FANTASTIC TEACHING!!

    legowisko

    (September 21, 2017 - 1:00 pm)

    Thank you very much for this tutorial. This series is really helpful, and also easy to follow. Great work!

    dnyaneshwar53

    (September 21, 2017 - 1:00 pm)

    Just Started learning VBA & your videos are very useful 🙂 WiseOwl you are the best……..!

    Pramod Upadhyay

    (September 21, 2017 - 1:00 pm)

    The Best Help to understand VBA as no one has explained it in such a deep explaination …

    Mauro Castagnera

    (September 21, 2017 - 1:00 pm)

    Extremely great tutorials starting from the basics to add a little at a time what it takes to improve the level of knowledge.
    Dear Andrew it is a pleasure to be listening to you and thank you for the amazing work you did and for having shared your knowledge.

    akhilesh singh

    (September 21, 2017 - 1:00 pm)

    how much time will it take to master vba wiseowl?

    Anthony Aguirre

    (September 21, 2017 - 1:00 pm)

    started working through the series…good stuff.

    Martha Asiimwe

    (September 21, 2017 - 1:00 pm)

    Thank you so much for your videos.

    I have a problem with my code and could use your help. I am trying to input data into my excel sheet from another workbook using a user form with a few drop down lists. I am able to open this other work book however, while assigning data from it to the dropdown lists in my userform; I keep getting errors. This is the code that produces the errors:

    dim LastRow as String
    Set LastRow = workbooks("C:file.xls").Sheets("SheetName").Range("RangeName" & Rows.Count).End(xlUp).Row

    I am at wits end and would appreciate some insight.

    CHAOUDI IBRAHIM

    (September 21, 2017 - 1:00 pm)

    you are the Best big up

    Rolf Doets

    (September 21, 2017 - 1:00 pm)

    Nice and joyful voice makes it clear

    Mauro Castagnera

    (September 21, 2017 - 1:00 pm)

    Dear Sir, J started seriously learning VBA thanks to your videos and although J'm just at third, J've already realized that you did an excellent work. J am very grateful to you because my professionalism will go up and in the same time J'll perfect my English. J'm really excited to start this new adventure that gives me great personal gratification not only at work. J think at any age you should never stop learning. Thank you very much for your great and precious work. Best regards from Italy.

    Mthobeki Sikhosana

    (September 21, 2017 - 1:00 pm)

    I don't get the Debug Toolbar

    Mohamed Fahmy

    (September 21, 2017 - 1:00 pm)

    What to do when "context sensitive help" disappears in VBA? How to get it back?

    Nick Benjamin

    (September 21, 2017 - 1:00 pm)

    very well done, really appreciate the way you explain in an easy way

    UltraMovies

    (September 21, 2017 - 1:00 pm)

    thx a lot sir and god bless you ..i am a master student and u helped me a lot with this topic for free 🙂 .. cheers

    Natali Wagner

    (September 21, 2017 - 1:00 pm)

    Hey! Pretty good tutorial! Love your accent:)

    krmnjm

    (September 21, 2017 - 1:00 pm)

    I think this is the best site to learn Excel VBA. Do you have written material on this?

    Katherine Turkiewicz-Cisek

    (September 21, 2017 - 1:00 pm)

    Enjoyed this tutorial, I will second the accent comment, excellent!!

    XIAOXUE LI

    (September 21, 2017 - 1:00 pm)

    Love the tutorial!!! It is easy to follow step by step!

    Nick Khalaieff

    (September 21, 2017 - 1:00 pm)

    Thank you for this video.

    Mutlu Gundiler

    (September 21, 2017 - 1:00 pm)

    Dear WiseOwl.
    You are the greatest teacher on this topic, period.
    Almost every sentence you speak out conveys a meticulously selected piece of information which learners would spend plenty of time figuring out, if at all.
    Besides, your perfect accent cleans off the rust from my ears.
    Thank you.

    networking

    (September 21, 2017 - 1:00 pm)

    Great accent, great tutorials. Its nice that you get into the the detail of the issues, where we get stuck while working. I am really learning. Thanks for your hard work.

    Heights Library

    (September 21, 2017 - 1:00 pm)

    Why use the open and close quotes before and after A1 in the range routine? I thought you used quotes to indicate natural language.

    Akshay Ajmera

    (September 21, 2017 - 1:00 pm)

    why breakmode is not good

    sean chua

    (September 21, 2017 - 1:00 pm)

    Hi ya thank you for your video firstly,

    i got a couple of questions when i actually hit ctrl + space, it only changes my keyboard language to other language instead of opening up the library of command. is there anywhere that i could open up the list of command in alternative means?

    secondly, when i actually rewrite your code in your second video and hit run, it shows me that an error 434 has been found and object required. is there anything wrong with it?.

    thank you..

    MathCruz

    (September 21, 2017 - 1:00 pm)

    so when I write a code and save it…. maybe in a ribbon…. will it be available in every workbook going forward or just the workbook I'm currently in

    mervin1947

    (September 21, 2017 - 1:00 pm)

    I am a self taught person and I have been programming for some 5 years in VBA, and still in the first few lessons I learned something new.
    I must say , it is very well presented and simply explained.

    Waqar video

    (September 21, 2017 - 1:00 pm)

    Your videos are full of knowledge but I wanna ask a question.
    Why do you pronounce the letter R very differently from other english people all the time.

    Waqar video

    (September 21, 2017 - 1:00 pm)

    Your videos are full of knowledge but I wanna ask a question.
    Why do you pronounce the letter R very differently from other english people all the time.

    Shabana Aazmi

    (September 21, 2017 - 1:00 pm)

    In love with your accent lol 😀 thanks for the tutorials they are amazing

    ExceLPower

    (September 21, 2017 - 1:00 pm)

    Your videos are owesome. Your accent is lovely.

    CHUN Nimul

    (September 21, 2017 - 1:00 pm)

    Best Excel VBA ever watch !

    Frank Wu

    (September 21, 2017 - 1:00 pm)

    this is more than great. The quality is at par or even higher than some paid tutorials.

    Sea AlBahr

    (September 21, 2017 - 1:00 pm)

    Excellent video many thanks

    Peter Batah

    (September 21, 2017 - 1:00 pm)

    Are excercise files used in this tutorial series available at WiseOwl? Thank you for sharing your time and knowledge with us.

Leave a Reply

Your email address will not be published. Required fields are marked *