I have been studying VBA literally from your videos. I have bought books to study, but through your videos is much easier and faster. Thank you for the videos. I'm grateful
These videos are a treasure trove. After many years of producing them, the teaching techniques are still top-notch and make VBA easier to digest. I run to these playlists each time VBA documentation starts getting too abstract to wrap my head around. I'm super thankful for not dropping the ball when the videos still had low visibility ❤
@@Kingco245 Hi! We don't have a Wise Owl Excel community but there are plenty of others out there! You could start here techcommunity.microsoft.com/t5/excel/welcome-to-the-excel-community/m-p/7715 I hope it helps!
Love your videos Andy! Thank you for putting in the time and effort for making these and especially publishing them for FREE for us to consume and learn. Your efforts definitely don't go unnoticed as with every video in this playlist!
Dear Mr. Andrew. No words can thank you enough. What a wonderful delivery of knowledge sharing You are doing. I have been able to create an excellent maintenance management system using excel vba by seeing your tutorials. I am a mechanical engineer and developing a system was need of the hour. Once again thank you.
I’ve searched online for a while looking for explanations that are clear and comprehensive and finally I found them in this video. Thank you for publishing this, this has really helped me write better code for my projects!
out of all the youtube channels on vba, you are the best for helping beginners understand the concepts in a way that can be used right after the video is over! thank you for being great! :)
Hi Andrew! Just wanted to give you huge props for your excellent videos. Without exaggerating your videos are some of the best educational videos I've watched. Every time a question comes up when watching your videos the second after you answer it. Very well thought through and pedagogical clips! I'll certainly continue to explore and learn VBA further as you post your clips.It's plain fun learning VBA with Andrew behind the mic! :)
Yes. I found the real VB teacher. Thanks for this video, The presentations in this video was awesome. Now i can handle different errors in VB. Thanks New WiseOwlTutorials Subscriber :)
As many others have said, you really do have a gift for teaching; truly the best tutorial videos I've seen online. I've watched basically the entire SSRS series and VBA series, and have learned SO MUCH, I don't know what I would have done without your tutorials, but now I'm even thinking of getting more into programming. I've watched so many of these videos I almost feel like I know you now haha. I'll be in London in/around November, can I buy you some pints for improving my career/knowledge? =)
Thank you Andrew, you are life saver. Your vedios help me to complete my task. Whenever I face issue, I approach to your vedios. They are really helpful. I really greatful 😊
Thank you so much for this tutorial. You did an excellent job explaining the topic without a lot of unnecessary material. It has been very difficult to find good tutorials, and I will be taking a look at what else you have to offer.
THANK YOU VERY MUCH !!! Your Tutorials are really fantastic, you explain very well and I use them for my professional work. Fortunately they are LONG... that is the way to learn efficiancy. Best regards Paulo
Great video as always! And I have a suggestion: When using previous excel sheet examples, where there are formula already filled in, I would recommend to leave in the description a link (e.g. in dropbox) where the base of the macro can be easily downloaded. In this way people don't have to rewrite it by hand, nor have to look into the previous VBA classes to take the code (also because people like me like to change a little bit the code to make tests and what not, so the macro will never be the same as the one you make). Hope this feedback helps!
Hey Andrew, really awesome videos, saw them all ( your VBA series), enjoyed a lot, still learning ( and have a lot to learn), and waiting for more... :-) Thanks....
@@WiseOwlTutorials how can I take VBA courses online or in person through your organization ? I am in Egypt but willing to travel to the UK 🇬🇧 to take the courses
Yes...I agree Andrew is the best and knows how to teach VBA. Thank you!! Are you thinking to do videos on UserForms? That would be awesome. Thank you again.
me ha sido de mucha utilidad el video para realizar un codigo en el control de errores en unos de mis desarrollos me costo trabajo entender la estructura pero gracias a ti logre implementarlo correctamente
Finally! A demonstration where the content is useful and the teacher doesn't just storm through the data leaving zero absorption time! I have an excel program which is used in the company I work for which comprises roughly 8 separate userforms. Currently when an error is thrown I use a custom message box based on the output from Select Case statement. Depending on this the program then selects a hidden sheet and adds the error data i.e. Number, description etc and also logs the username of the employee plus the date and time occurred. This is a lot of programming as it needs to be done at each potential instance of an error. Is there a more global way of capturing this data with a Public Sub? Your response would be greatly appreciated... Joel Byrne
Awesome explanation. Congratulations once again for the incredible content you're showing us here. One question, where can I find the errors numbers of each error?
I'm thankful for the series of videos and they are quite educational! You have a talent for teaching.. the best so far. However I also searched for Microsoft C# series. Do you have that available now? Thank you..
Hi Andrew, I have suggested two of my workmates to your videos. These are just awesome! thanks for your help. Are you going to publish videos on Class sooner?
Hi Andrew, Your videos are awesome. Can you please help on how can we control internal tools on our system using VBA. Does it require downloading external libraries like selenium ?
For anyone watching now, if whatever you do the error handling doesn't trigger, go to tools, options, general and change the error trapping option. This drove me crazy!
Thank you very much for this tutorial. I have a question .. @ 18:30 What if I wrote "GOTO GuessAgain" instead of "resume GuessAgain"? is there any difference? .. "resume" command can be used next I guess, but I can't think of a useful situation for this ...
Hi Andrew, I really liked the video it is fantastic as always. I have a question, I did a code (with the valuable help of your videos 😉) that enabled me to copy data from multiple workbooks to one worksheet, however the whole data were copied and I wanted data that are only valid for the criteria *breach*, so I applied the autofilter method but since some workbooks do not have this criteria in them, an error message keeps popping out and I got stoke there. Do you have any advise on this please ? Thank you very much 😊
mmm I ran into a funny scenario here. I'm not sure why. I ran the On Error GoTo CreateSheet45... which worked fine it created the sheet, then it jumped to a Function from video part 18 "Function CustomDate(DateToFormat As Date, Optional IncludeTime As Boolean = False) As String" very strange. my code is identical to yours?
Hi Andrew, thanks a ton for these amazing videos. i hope you dont mind directing me to solution to the problem i am facing with one of my application. i have a data analyzing sheet which import raw data and create a new sheet named with that criteria i have put, the problem is when someone run twice the same criteria it comes with a obvious error as workbook cant have 2 sheets with same name. is there any way that i can put in my error handler to check if the sheet already exists and tell the user that its already exists... to handle the error gracefully i guess.
@@WiseOwlTutorials Please answer my question, need your response: is VBA stil relevant as a tool in different nowadays tasks and in demand by IT-companies?
Good morning, I enjoyed this video and was able to get a little further in coding.. My question to you is that I'm working in Access, so I hope you’re still able to help me out. Form B gets information from Form A; if the information in Form A doesn't exist I get a msg box letting me know. I then go to Form A (without deleting the information I just typed in Form B that caused the msg box to pop up), I then enter the new record in Form A. I go back to Form B to continue on and I still receive the same msg box, I have to select new record and re-enter the information for it to show up without giving me the msg box error. I would like Form B to recognize the update in Form A and let me continue on without having to select a new record. Is this possible? I’m not using a module I’m putting code in the before_event.Thank you for your time.Nanette
Whenever I try to use goto two times within a code, the second time around it doesn't work. I have a user entering an input into an input box and this is used to pull data from a file. If the user enters a certain type of file, it pulls data from the file. If excel cannot find it, I have vba go to an error handler which asks the user to reenter the file and then vba looks for it again. However, on the second time around, if excel still can't find it, a run time error 1004 pops up. My question is why doesn't the error handler send the program to the label the second time around?
Any one plz guide me that how can an error 1004 be removed? Its a Run Time error in MS Excel (stats tool package2). Early guidance may plz be solicited.
Hi WiseOwl, I am getting an error when trying to run a template which has macro(Vba) coding in backend. The error message is " 57121 Application defined or object defined Error". I tried finding search,and i saw about activex setting in excel but that didn't work, even macros are in enabled mode. Now the problem is that the excel sheet containing macros run on some machines. I don't know whats wrong in some systems. Will appreciate any suggestion that may work. :):)
+WiseOwlTutorials Yes activeX control is enabled in all machines.As i wrote previously the error is 57121,while debug there is no specific line highlighted, i think the objects are not recognized as a result there is a problem in the methods. Any specific solution that u suggest?
Wise Owl, thank You for all Your VBA videos, You are truly very wise. I have a weird problem which happened a few times now, if You would be so kind as to help me. Excuse me for the formatting, but for some reason TH-cam changes it every time . I wrote a similar code like You: Sub ErrorsInVBA() On Error Resume Next Application.DisplayAlerts = False Worksheets("Sheet42").Delete Application.DisplayAlerts = True End SubIf I don't have a "Sheet42" this all runs fine and dandy. But, if I do have a "Sheet42", stepping through the code I get to Worksheets("Sheet42").delete, then I press f8 and I am transported to my Creating Functions pt1 module, to a function CustomDatabase, which You covered in an earlier video. Function CustomDate(DateToFormat As Date, Optional IncludeTime As Boolean = False) As String 'Boolean = false means that if the user doesn't type in data _ the default value would in this case be false; can be true If IncludeTime Then CustomDate = Format(DateToFormat, "dddd dd mmmm yyyy hh:mm:ss") Else CustomDate = Format(DateToFormat, "dddd dd mmmm yyyy") End If End Function This complete function runs, which means it ends, and than I am transported back to ErrorHandling module, to Application.DisplayAlerts = True.This happened already a few times with different subroutines but I ignored it. Now it seems that it will keep bugging me. Do you know what's the problem here?Kind regards,Fran
***** Dude I really love ur videos they are awsome. I have no issue with the content and information provided and the examples you provide makes it easy to understand the topics...thank you for doing these :)
+WiseOwlTutorials Beneath the video just stick in the links to the individual sections (youtube can link to time). Appreciate this takes time, so if I'm taking notes to some of your videos I'll send you my links.
I have been studying VBA literally from your videos. I have bought books to study, but through your videos is much easier and faster. Thank you for the videos. I'm grateful
These videos are a treasure trove. After many years of producing them, the teaching techniques are still top-notch and make VBA easier to digest. I run to these playlists each time VBA documentation starts getting too abstract to wrap my head around. I'm super thankful for not dropping the ball when the videos still had low visibility ❤
Really happy to hear that you've found the videos useful for so long! Thanks for watching and for taking the time to write a comment!
You are welcome. Do you have an Excel community I can join? I want to be around people who are passionate about Excel
@@Kingco245 Hi! We don't have a Wise Owl Excel community but there are plenty of others out there! You could start here techcommunity.microsoft.com/t5/excel/welcome-to-the-excel-community/m-p/7715
I hope it helps!
You teach as if the viewers knows nothing which I think is the best part in your videos... GREAT
Best best vba series on the Internet.... Wish i found it earlier.... Thanks alot for sharing knowledge
Hi Andrew, Welcome back on vba videos. The best one online.
Teaching is a gift and you have it.
Thank you so much.
Love your videos Andy! Thank you for putting in the time and effort for making these and especially publishing them for FREE for us to consume and learn. Your efforts definitely don't go unnoticed as with every video in this playlist!
You're welcome Qasim! Happy to hear you're finding the videos useful and thanks for watching!
Dear Mr. Andrew. No words can thank you enough. What a wonderful delivery of knowledge sharing You are doing. I have been able to create an excellent maintenance management system using excel vba by seeing your tutorials. I am a mechanical engineer and developing a system was need of the hour. Once again thank you.
#################################
I’ve searched online for a while looking for explanations that are clear and comprehensive and finally I found them in this video. Thank you for publishing this, this has really helped me write better code for my projects!
Happy to hear that, Natalie! Thanks for watching and for taking the time to add a comment!
out of all the youtube channels on vba, you are the best for helping beginners understand the concepts in a way that can be used right after the video is over! thank you for being great! :)
You are GOD of the universe Andrew Gould
Hi Andrew!
Just wanted to give you huge props for your excellent videos.
Without exaggerating your videos are some of the best educational videos I've watched. Every time a question comes up when watching your videos the second after you answer it. Very well thought through and pedagogical clips! I'll certainly continue to explore and learn VBA further as you post your clips.It's plain fun learning VBA with Andrew behind the mic! :)
Thank you Andrew! I think thanks to you I'll pass my computer science exam.
Sooo grateful.
Thanks for the crystal clear explanation!!
You're welcome, David. Thanks for watching!
Yes. I found the real VB teacher. Thanks for this video, The presentations in this video was awesome. Now i can handle different errors in VB.
Thanks
New WiseOwlTutorials Subscriber :)
Bonjour merci encore. Je suis à la 19ème vidéo. Vous êtes un vrai pédagogue. Continuez...
Omg.... I tried to find an answer for this for about 30mins... You are a legend.
Sheet42: the answer to life, the universe, and everything
Vidéo très passionnante. Merci. Amicalement.
As many others have said, you really do have a gift for teaching; truly the best tutorial videos I've seen online. I've watched basically the entire SSRS series and VBA series, and have learned SO MUCH, I don't know what I would have done without your tutorials, but now I'm even thinking of getting more into programming. I've watched so many of these videos I almost feel like I know you now haha. I'll be in London in/around November, can I buy you some pints for improving my career/knowledge? =)
Andrew your the best I ever seen: the way u organised the videos are simply awesome! In an every videos of yours I get some trivia and so on...
Great video! You can also track the exact line number of an error by using the Erl function (if you add VBA line numbers).
Thanks, Andrew for the wonderful video.
You're welcome Sayyad, thank you for watching!
Thank you Andrew, you are life saver. Your vedios help me to complete my task. Whenever I face issue, I approach to your vedios. They are really helpful. I really greatful 😊
Comprehensive tutorial !
Thanks!
Thank you so much for this tutorial. You did an excellent job explaining the topic without a lot of unnecessary material. It has been very difficult to find good tutorials, and I will be taking a look at what else you have to offer.
thank you for developing these VBA videos
THANK YOU VERY MUCH !!!
Your Tutorials are really fantastic, you explain very well and I use them for my professional work.
Fortunately they are LONG... that is the way to learn efficiancy.
Best regards
Paulo
Wow, superb explanation, i have learnt VBA from you only, thank you so much
You Andrew are simply a genius! 👏👏👏
Great video as always! And I have a suggestion: When using previous excel sheet examples, where there are formula already filled in, I would recommend to leave in the description a link (e.g. in dropbox) where the base of the macro can be easily downloaded. In this way people don't have to rewrite it by hand, nor have to look into the previous VBA classes to take the code (also because people like me like to change a little bit the code to make tests and what not, so the macro will never be the same as the one you make). Hope this feedback helps!
Superb Andrew Gould
very very helping indeed
thank you very much
Its just great. I have learnt a lot from these videos.
Hey Andrew, really awesome videos, saw them all ( your VBA series), enjoyed a lot, still learning ( and have a lot to learn), and waiting for more... :-)
Thanks....
Great video 📹 👍 Thank you for your hard work
You're welcome Nader, thanks for watching!
@@WiseOwlTutorials how can I take VBA courses online or in person through your organization ? I am in Egypt but willing to travel to the UK 🇬🇧 to take the courses
@@nadermounir8228 Hi Nader, you can find information on dates, prices and the booking process on our website www.wiseowl.co.uk/
I hope it helps!
Brilliant! - found exactly what I was looking for, and some unexpected surprises which will come in really handy!
This video saved my life.
another amazing video. thanks!
Yes...I agree Andrew is the best and knows how to teach VBA. Thank you!!
Are you thinking to do videos on UserForms? That would be awesome. Thank you again.
Fantastic as always!
Your videos really simple and easy to understand.
Could you please do a video on Storage Item?
it would be a great help
me ha sido de mucha utilidad el video para realizar un codigo en el control de errores en unos de mis desarrollos me costo trabajo entender la estructura pero gracias a ti logre implementarlo correctamente
Thanks! Error handled succesfully :)
Thank you, Wise Sir.
Will surely watch all your vids including the ads haha! These type of vids are worth the ads!
Amazing tutorial, thanks a lot!!
Finally! A demonstration where the content is useful and the teacher doesn't just storm through the data leaving zero absorption time!
I have an excel program which is used in the company I work for which comprises roughly 8 separate userforms. Currently when an error is thrown I use a custom message box based on the output from Select Case statement. Depending on this the program then selects a hidden sheet and adds the error data i.e. Number, description etc and also logs the username of the employee plus the date and time occurred. This is a lot of programming as it needs to be done at each potential instance of an error.
Is there a more global way of capturing this data with a Public Sub?
Your response would be greatly appreciated...
Joel Byrne
Thank you for an interesting video. It's a pity that I didn't find it a year ago - it would save me a lot of lost time.
Awesome explanation. Congratulations once again for the incredible content you're showing us here. One question, where can I find the errors numbers of each error?
I love your videos!
I'm thankful for the series of videos and they are quite educational! You have a talent for teaching.. the best so far. However I also searched for Microsoft C# series. Do you have that available now? Thank you..
Excellent. Thank you
good presentation
Hi Andrew, I have suggested two of my workmates to your videos. These are just awesome! thanks for your help. Are you going to publish videos on Class sooner?
very good video!
Thank you!
awesome training collection Andrew, could you please upload Ms Access trainings if it is available with you it would be really helpful..
Very nice Sir.
I've read that the clunky On Error thing will be replaced by the standard try/catch in the future.
Hi Andrew,
Your videos are awesome.
Can you please help on how can we control internal tools on our system using VBA.
Does it require downloading external libraries like selenium ?
For anyone watching now, if whatever you do the error handling doesn't trigger, go to tools, options, general and change the error trapping option. This drove me crazy!
Thank you!
@WiseOwlTutorials, May you tell me, is VBA stil relevant as a tool in different nowadays tasks and in demand by IT-companies?
Thank you very much for this tutorial. I have a question .. @ 18:30
What if I wrote "GOTO GuessAgain" instead of "resume GuessAgain"?
is there any difference? .. "resume" command can be used next I guess, but I can't think of a useful situation for this ...
Hi Andrew, I really liked the video it is fantastic as always.
I have a question, I did a code (with the valuable help of your videos 😉) that enabled me to copy data from multiple workbooks to one worksheet, however the whole data were copied and I wanted data that are only valid for the criteria *breach*, so I applied the autofilter method but since some workbooks do not have this criteria in them, an error message keeps popping out and I got stoke there. Do you have any advise on this please ?
Thank you very much 😊
Hi Naima! Can you post your code here and show the exact text of the error message you see and indicate which line causes the error?
mmm I ran into a funny scenario here. I'm not sure why. I ran the On Error GoTo CreateSheet45... which worked fine it created the sheet, then it jumped to a Function from video part 18 "Function CustomDate(DateToFormat As Date, Optional IncludeTime As Boolean = False) As String" very strange. my code is identical to yours?
thank you
please help!
which free software is best for screen recording while in debug mode??
Hi Andrew, thanks a ton for these amazing videos. i hope you dont mind directing me to solution to the problem i am facing with one of my application. i have a data analyzing sheet which import raw data and create a new sheet named with that criteria i have put, the problem is when someone run twice the same criteria it comes with a obvious error as workbook cant have 2 sheets with same name. is there any way that i can put in my error handler to check if the sheet already exists and tell the user that its already exists... to handle the error gracefully i guess.
You are a life saver Andrew, can't thank you enough
very helpful
why cant you put the error handler after the end sub part that would save you having to put exit sub???
@@WiseOwlTutorials Please answer my question, need your response: is VBA stil relevant as a tool in different nowadays tasks and in demand by IT-companies?
Good morning, I enjoyed this
video and was able to get a little further in coding.. My question to you is that I'm working in Access, so I hope you’re still able to help me out.
Form B gets information from Form A; if the information in Form A doesn't exist I get a msg box letting me know. I then go to Form A (without deleting the information I just typed in Form B that caused the msg box to pop up), I then enter the new record in Form A. I go back to Form B to continue on and I still receive the same msg box, I have to select new record and re-enter the information for it to show up without giving me the msg box error.
I would like Form B to recognize the update in Form A and let me continue on without having to select a new record. Is this possible? I’m not using a module I’m putting code in the before_event.Thank you for your time.Nanette
Whenever I try to use goto two times within a code, the second time around it doesn't work. I have a user entering an input into an input box and this is used to pull data from a file. If the user enters a certain type of file, it pulls data from the file. If excel cannot find it, I have vba go to an error handler which asks the user to reenter the file and then vba looks for it again. However, on the second time around, if excel still can't find it, a run time error 1004 pops up. My question is why doesn't the error handler send the program to the label the second time around?
*****
Works perfectly! Thanks :)
any info about "On Error GoTo -1" ?
Great video but sound quality is very low
thanks!!!!!!!!!!!!!
Any one plz guide me that how can an error 1004 be removed? Its a Run Time error in MS Excel (stats tool package2). Early guidance may plz be solicited.
Hi WiseOwl,
I am getting an error when trying to run a template which has macro(Vba) coding in backend.
The error message is " 57121 Application defined or object defined Error".
I tried finding search,and i saw about activex setting in excel but that didn't work, even macros are in enabled mode.
Now the problem is that the excel sheet containing macros run on some machines. I don't know whats wrong in some systems.
Will appreciate any suggestion that may work. :):)
+WiseOwlTutorials Yes activeX control is enabled in all machines.As i wrote previously the error is 57121,while debug there is no specific line highlighted, i think the objects are not recognized as a result there is a problem in the methods. Any specific solution that u suggest?
Wise Owl, thank You for all Your VBA videos, You are truly very wise. I have a weird problem which happened a few times now, if You would be so kind as to help me. Excuse me for the formatting, but for some reason TH-cam changes it every time . I wrote a similar code like You:
Sub ErrorsInVBA()
On Error Resume Next
Application.DisplayAlerts = False
Worksheets("Sheet42").Delete
Application.DisplayAlerts = True
End SubIf I don't have a "Sheet42" this all runs fine and dandy. But, if I do have a "Sheet42", stepping through the code I get to Worksheets("Sheet42").delete, then I press f8 and I am transported to my Creating Functions pt1 module, to a function CustomDatabase, which You covered in an earlier video. Function CustomDate(DateToFormat As Date, Optional IncludeTime As Boolean = False) As String
'Boolean = false means that if the user doesn't type in data _
the default value would in this case be false; can be true
If IncludeTime Then
CustomDate = Format(DateToFormat, "dddd dd mmmm yyyy hh:mm:ss")
Else
CustomDate = Format(DateToFormat, "dddd dd mmmm yyyy")
End If
End Function
This complete function runs, which means it ends, and than I am transported back to ErrorHandling module, to Application.DisplayAlerts = True.This happened already a few times with different subroutines but I ignored it. Now it seems that it will keep bugging me. Do you know what's the problem here?Kind regards,Fran
Sub'd by the way
Have you thought about putting your courses on Udemy?
Dude your videos are very awesome but they are too long
***** Dude I really love ur videos they are awsome. I have no issue with the content and information provided and the examples you provide makes it easy to understand the topics...thank you for doing these :)
+WiseOwlTutorials Beneath the video just stick in the links to the individual sections (youtube can link to time). Appreciate this takes time, so if I'm taking notes to some of your videos I'll send you my links.