I'm a Computer science student, and your videos strike me as really understandable, concise and at a good pace. You also have a really pleasant voice. Keep up the work, educating the masses via TH-cam! Love what educators like Khan Academy, MOOCs and you are doing
I have just gone over all the VBA videos that I have watched. Amazingly, I find myself familiar with most everything I saw. Is possible because I have watched your videos on VBA & User forms DOZENS of times. You are by far the best VBA Teacherin this You Tub Community. I am 73 years old, and have been watching your videos for a couple of yrs now. You can teach an Old Dog new tricks. Thank You from the bottom of my heart. Well done. (long live the Cichlids)
Very good video!! Been doing vba for few weeks. Most courses assume we understand navigation when we often don’t. This video is the best way to start a course!!
You are a great VBA teacher. Impressive!!!! I feel confident that after watching all your VBA videos I should be able to move from recording macros to 'writing' macros. I've been intimidated by trying to write one. Thanks for taking time to put these videos together. Extremely helpful.
I'm not hating at all (please no flaming), but its sooooo freshing to hear an English accent on a programming tutorial video. I'm currently using TH-cam to learn VB.NET, SQL, ASP.NET and a range of others and all the videos I have watched they have been American/Indian. I have no problem with that at all but its good to see the UK has some programming skills! Great tutorial, really easy to follow and I learnt a lot. Time to watch the rest of your videos :D
When I saw this video I immediately realized that these vba video tutorials were what I was looking for a long time, because they explained in a really clear and simple way. Excellent teacher!
For Efficient Reference: Creating a New Module 1:48 Beginning a New Sub-Routine 2:32 Laying out Your Code Neatly 4:09 Adding Comments to Code 5:19 The Basic Syntax of VBA Instructions 6:55 Referring to a Cell 9:31 Copying and Pasting Code 12:38 Using Functions to Calculate Values 13:43 Formatting Cells 16:53 Saving Workbooks Containing Code 22:23 Running Code from the VB Editor 24:35 Running Code from Excel 27:15 Opening Files with Code in Excel 2010 27:15 Opening Files with Code in Excel 2007 30:34 Opening Files with Code in earlier Excel 31:36
Andrew, Thanks for this. I have just retired. I am a competent Excel User, but thought for my first retirement goal, I would upgrade myself to a Master User. I've looked around for courses, but can't find anything locally. I wondered if I could self educate through TH-cam. Your video (plus one other that I just reviewed) convinces me that this is not only possible, but probably the best way. I think your comment that video training might be superior to class room training might be profoundly right. The absolute best way to learn is with a personal tutor or full time mentor. But a well done group of videos could well be the second best way. I must go now to see how much of what I just watched I can reproduce on my own. When I get stuck I will just go back to the video to resolve what I have not absorbed yet. Thanks again. Bill
Thank you so much! I have been putting learning VBA off for far too long because I was scared that I would never understand, but you make this very simple, easy, and straight forward!
Thank you very much for your videos. I'm trying to understand language because I'm not English, but I think they are the best videos about VBA I've ever seen!
There is no more comment than the comment of the previous brothers below, but I say the videos of Professor Andrew answer all the questions of those who want to enter this field and clearly. True with all my heart to all of the thanks, love and friendliness🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹
Hi Andrew, I have told many people about your videos and how good they are. Today, I did some searching on the web and found out that you have a book on Excel VBA programming. I've ordered your book from lulu.com. I look forward to the book as well as watching more of your videos. By the way , I have been doing Excel VBA programming for quite a few years and consider myself fairly knowledgeable in this area. Even with all this so-called knowledge, I still find your videos extremely useful. Thanks again for these wonderful tutorials.
This was so helpful! I offered to complete a task for work using macros, something in which I had no experience, and I think I still would have been sitting at my desk staring confusedly at Google if not for your detailed video. Thank you! I did appreciate how gentle the guidance was :)
well done!!! From start to finish, each video is well thought out and presented in a clear concise manner. Great for us visual / audio learners. Again Thanks
Hello Sir, Thank you very much for your great teaching method, you are the best among all the VBA teachers I have ever found in TH-cam. I think anyone can learn VBA quickly with this type of teaching method. I am very glad that I found your channel. your channel will help me to grow in my career. Thanks a lot once again. Keep up the awesome work.
Thank you WiseOwlTutorials for the beginning of what I am sure will be a very useful VBA video tutorial series. It has been a while since I viewed your first VBA video but, after viewing this one, I have once again renewed my interest in learning more VBA. Great job.
Very nice video. Very clear, very descriptive, right pacing and chocked full of knowledge. Very nearly the best presentation I have seen on how to's anywhere. Great job.....
I've watched parts 1 and 2 of this series and both are excellent. The pace is great--not too fast, so I can "play along" as the video plays. Recommend this for a very beginner (like me).
Great. It was really useful to see the types of objects we can select and how they can be modified. My code sheet has given me some great notes I can refer back to. Nicely structured video.
Hi Andrew, i checked tons of tutors and up to now you're the best vba tutor ever seen, well explained, and easy to understand the details Thank you so much and god bless you for sharing your knowledge .. - BTW : About your name in the code, If the first sheet was deleted, then after you run the code a few times and your name appear, then from where the Environ("username") Take your name??,(after sheet deletion your name was recorded inside Environ or remained in memory?) some other student ask you the same and you answer was : "My name is generated by the Environ function. So, the line which reads: Range("B1").Value = Environ("UserName") places the current user name into cell B1." , - But supposedly the B1 of all the sheet are empty until code is clicked, Please andrew don't get mad, i'm just curious .. Best regards Andy
Wow, why couldn't you be my teacher for all subjects from grades 5 till high school? Awesome video, I am so excited to start my journey into writing my own program :)
They just get better. So many You-tube video producers "wing it"; don't prepare, stumble around, constantly backtrack to correct typo's etc. Your videos are clean, well thought out, and direct. I've just finished watching Part 4; I was surprised by how long it was and by how much information it provided on the many options that are available. I wish I was in the UK, so I could take some of your courses!
Checked your video for only couple minutes and then subscribed immediately. I appreciate your time and allowing sharing your knowledge for free, while other training sites charge hundreds of $ if not thousands. I like your teaching skills and wish you start a session of the Self Power BI. I can't find good free training videos except one for ExcelisFun. I will be watching all your videos for sure! Keep up the great work.
Great Video! I've been writing VBA code, but I had always been confused about the definitions of methods, properties and functions. Thanks for clarifying
Bought a book some time ago. Didn't make any progress with it. Examples were to singleminded. Made a lot of progress with your vids though. So thanks a lot! =)
Hii Tq for detailed classes ..but I find the feature itelisense ..which shows scroll down for different methods ..do I need to add any settings for the drop down of methods
Hi WiseOwl, which video will be most useful to use to create a script to combine one specific worksheet of multiple workbooks from one directory to an existing excel worksheet. The specific worksheet has the same layout as the existing excel worksheet. Thank you in advance voor your help.
19:20 Hi there from America....Yeah sorry about that...we really butchered your language :p I've actually always wondered how those Yankees developed their own accents Great tutorial. I have been writing formulas for a few years now and thought VBA would be too complex for me to learn. However, so far you're making it look possible for me. thx
Excellent teaching! Thanks. One question, when I hit Ctrl - Space, no anything showed in VBA editor. Could you please let me know how to enable that feature in my VBA? I am using Excel 2007. Thanks.
Hello, I have a question regarding the cell dimension. I have a master sheets (Sheet1) and I create multiple sheets sorted by a specific column located in the master Sheet1. How can I have the cell dimension in the other sheets as same as the cell dimension in master ? thank you
Awesome video clip. I really appreciate for the video clips that you uploaded. Is there any chance you will show tutorials such as Access VBA programming for beginner?
You are teaching the basics in the best way possible. Thank you.
+WiseOwlTutorials Sir But How you add andrew.gowl in the code name was not mention
+prasanth dhanu got it thank you
know only i saw key word environ
I'm a Computer science student, and your videos strike me as really understandable, concise and at a good pace. You also have a really pleasant voice. Keep up the work, educating the masses via TH-cam! Love what educators like Khan Academy, MOOCs and you are doing
this is probably the best tutorial i have seen for a youtube video
I have just gone over all the VBA videos that I have watched. Amazingly, I find myself familiar with most everything I saw. Is possible because I have watched your videos on VBA & User forms DOZENS of times. You are by far the best VBA Teacherin this You Tub Community. I am 73 years old, and have been watching your videos for a couple of yrs now. You can teach an Old Dog new tricks. Thank You from the bottom of my heart. Well done. (long live the Cichlids)
Apparently, the way of demonstrating is carefully designed. Very easy for layman like I am to comprehend. Big thank you to you!
Very good video!! Been doing vba for few weeks. Most courses assume we understand navigation when we often don’t. This video is the best way to start a course!!
Thank you for the kind comments, Peter! Happy to hear that you found the video useful and thank you for taking the time to leave a comment!
You are a great VBA teacher. Impressive!!!! I feel confident that after watching all your VBA videos I should be able to move from recording macros to 'writing' macros. I've been intimidated by trying to write one. Thanks for taking time to put these videos together. Extremely helpful.
I'm not hating at all (please no flaming), but its sooooo freshing to hear an English accent on a programming tutorial video. I'm currently using TH-cam to learn VB.NET, SQL, ASP.NET and a range of others and all the videos I have watched they have been American/Indian. I have no problem with that at all but its good to see the UK has some programming skills! Great tutorial, really easy to follow and I learnt a lot. Time to watch the rest of your videos :D
I tried since many years to learn VBA for excel... finally I found Wise Owl... You are amazing ! Thanks a lot ! May God Bless you !
When I saw this video I immediately realized that these vba video tutorials were what I was looking for a long time, because they explained in a really clear and simple way. Excellent
teacher!
Thank you for your lectures. I am going to watch the rest of 142 videos. They are wonderful. I like them all.
Thanks Elcidio, I hope you enjoy the videos!
my teacher set me homework over christmas to learn basic vba. i guess i am done thanks to you so thank you. you're a legend
For Efficient Reference:
Creating a New Module 1:48
Beginning a New Sub-Routine 2:32
Laying out Your Code Neatly 4:09
Adding Comments to Code 5:19
The Basic Syntax of VBA Instructions 6:55
Referring to a Cell 9:31
Copying and Pasting Code 12:38
Using Functions to Calculate Values 13:43
Formatting Cells 16:53
Saving Workbooks Containing Code 22:23
Running Code from the VB Editor 24:35
Running Code from Excel 27:15
Opening Files with Code in Excel 2010 27:15
Opening Files with Code in Excel 2007 30:34
Opening Files with Code in earlier Excel 31:36
Thanks again for this Thomas!
Andrew, Thanks for this. I have just retired. I am a competent Excel User, but thought for my first retirement goal, I would upgrade myself to a Master User. I've looked around for courses, but can't find anything locally. I wondered if I could self educate through TH-cam. Your video (plus one other that I just reviewed) convinces me that this is not only possible, but probably the best way. I think your comment that video training might be superior to class room training might be profoundly right. The absolute best way to learn is with a personal tutor or full time mentor. But a well done group of videos could well be the second best way. I must go now to see how much of what I just watched I can reproduce on my own. When I get stuck I will just go back to the video to resolve what I have not absorbed yet. Thanks again. Bill
Thank you so much! I can not imagine the better way to explain VBA. Everything you are telling is so clear and easy to understand.
Thank you so much! I have been putting learning VBA off for far too long because I was scared that I would never understand, but you make this very simple, easy, and straight forward!
Great video, clear, concise, and at a pace that contributes to the learning process.
I know this sounds ridiculous, but finally someone explained why we code in that format-- easier to read. LOL. I really appreciate your video sir!
You are the best in VBA Excel programing till now in my personal view. 😊
You're just great!! You explain what is required without entering into unnecessary details. Thank you so much!
Starting from practically zero experience with VBA, this is a great tutorial! Quite clear with some rye humor. THX
Better explication then 2 books i bought !!! Keep on the good work
Thank you very much for your videos. I'm trying to understand language because I'm not English, but I think they are the best videos about VBA I've ever seen!
There is no more comment than the comment of the previous brothers below, but I say the videos of Professor Andrew answer all the questions of those who want to enter this field and clearly. True with all my heart to all of the thanks, love and friendliness🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹🌹
Thank you so much for all your kind comments Aamir!
Hi Andrew,
I have told many people about your videos and how good they are. Today, I did some searching on the web and found out that you have a book on Excel VBA programming. I've ordered your book from lulu.com. I look forward to the book as well as watching more of your videos. By the way , I have been doing Excel VBA programming for quite a few years and consider myself fairly knowledgeable in this area. Even with all this so-called knowledge, I still find your videos extremely useful. Thanks again for these wonderful tutorials.
This was so helpful! I offered to complete a task for work using macros, something in which I had no experience, and I think I still would have been sitting at my desk staring confusedly at Google if not for your detailed video. Thank you! I did appreciate how gentle the guidance was :)
well done!!! From start to finish, each video is well thought out and presented in a clear concise manner. Great for us visual / audio learners. Again Thanks
Thank you, Scott, I really appreciate that! Thank you for watching and for taking the time to leave a comment!
This is wonderful - and the series is exactly what I needed for quickly familiarizing myself with VBA.
Wise owl channel is our saviour
The best explanation I have ever heard on this topic. Great job!
first time I watched your tutorial video. i then appreciate how VBA works. Thank you very much for sharing this knowledge for free!
Hello Sir, Thank you very much for your great teaching method, you are the best among all the VBA teachers I have ever found in TH-cam. I think anyone can learn VBA quickly with this type of teaching method. I am very glad that I found your channel.
your channel will help me to grow in my career. Thanks a lot once again. Keep up the awesome work.
Thank you WiseOwlTutorials for the beginning of what I am sure will be a very useful VBA video tutorial series. It has been a while since I viewed your first VBA video but, after viewing this one, I have once again renewed my interest in learning more VBA. Great job.
Excel
Your course material no.1 among all the youtubers...Thanks for this valuable content
Thank you for being generous in sharing your knowledge on using VBA language!!! God bless you infinitely!!
Very nice video. Very clear, very descriptive, right pacing and chocked full of knowledge. Very nearly the best presentation I have seen on how to's anywhere. Great job.....
I've watched parts 1 and 2 of this series and both are excellent. The pace is great--not too fast, so I can "play along" as the video plays. Recommend this for a very beginner (like me).
Happy to hear that you're enjoying it, Rene! Thank you for watching and for taking the time to leave a comment!
Great. It was really useful to see the types of objects we can select and how they can be modified. My code sheet has given me some great notes I can refer back to. Nicely structured video.
You are indeed a Wise Owl. You got everything RIGHT. Request you to increase your volume and tone of the speech.
Hey man, i'm from Brazil, and the way that u teach it's so easy to understand, congratz thank u soo much for the help
You are an amazing teacher. You have done an excellent job. I also watched your video on SQL. Excellent job again!
Very informative and easy to watch with that soothing voice.
You are awesome Andrew. This the best channel to learn VBA. You are the best trainer. Keep up the good work
The best VBA video tutorial i've seen so far. Thankyou for sharing! I can understand this more than just reading it! 😊😊😊
Dear WiseOwl I will NEVER thank you enough!
Thank you Wise Owl for such useful and well structured lessons on VBA!!
Thanks so much for these well-designed tutorials. WiseOwl is the best!
Thank you for your knowledge and patience. Too many VBA videos out there assume knowledge you don't I appreciate it :). Subscribed :) Thanks wise owl!
Great video, simple easy to understand ...written my first code in VBA yey!!!!!
This is a great introduction and very easy to follow.
Very good tutorial, Your teaching style and Pace is wonderfully helpful, and just basic enough for a new VBA student like myself.
The way u teach is simply great !!!
Excellent.. Thanks Andrew for all the videos... You are my Guru....
Your ways of doing it makes me wanna continue learning it along.
You lay down the structure of a command very nicely. Thank you
You are very knowledgeable teacher. Thanks a lot for these training videos.
your tutorials are amazing. I am quite confident now to write a vba code👍
You have taught very important concepts to beginners.
Thank you Maroof!
Flying bricks and the Orwellian "Trust Centre" made my day :-) Thanks for these videos - really clear and exactly what I was looking for.
This is the tutorial which I am looking for. Thanks you very much for this tutorial. It helps me lot!
Hi Andrew, i checked tons of tutors and up to now you're the best vba tutor ever seen, well explained, and easy to understand the details Thank you so much and god bless you for sharing your knowledge .. - BTW : About your name in the code, If the first sheet was deleted, then after you run the code a few times and your name appear, then from where the Environ("username") Take your name??,(after sheet deletion your name was recorded inside Environ or remained in memory?) some other student ask you the same and you answer was : "My name is generated by the Environ function. So, the line which reads: Range("B1").Value = Environ("UserName") places the current user name into cell B1." , - But supposedly the B1 of all the sheet are empty until code is clicked, Please andrew don't get mad, i'm just curious ..
Best regards
Andy
Love your style of teaching, very easy to stay focused :)
thankyouthankyouthankyou! I have been searching for an introduction like this for quite some time!
Yup! Amazing teacher man! Teaching me all the basics I have been needing to know for so long! Hooked! :)
Wow, why couldn't you be my teacher for all subjects from grades 5 till high school?
Awesome video, I am so excited to start my journey into writing my own program :)
In the British vernacular: Brilliant! So glad I found these; plan to watch them all (-:
They just get better. So many You-tube video producers "wing it"; don't prepare, stumble around, constantly backtrack to correct typo's etc. Your videos are clean, well thought out, and direct. I've just finished watching Part 4; I was surprised by how long it was and by how much information it provided on the many options that are available. I wish I was in the UK, so I could take some of your courses!
Many thanks for this Video. Excellent !!! I will watch the rest of the videos. Five star quality teaching.
Awesome tutorial. Really a god sent for the guys starting out with VBA, Thanks WiseOwl. Cheers!
Thank you. So helpful. I hope your tutorials go into how to use functions and pull data and enter data. This is a great help for my class.
Thank you Mr. Wise Owl
It is very easy to understand the codes for beginners...God Bless
Checked your video for only couple minutes and then subscribed immediately. I appreciate your time and allowing sharing your knowledge for free, while other training sites charge hundreds of $ if not thousands. I like your teaching skills and wish you start a session of the Self Power BI. I can't find good free training videos except one for ExcelisFun.
I will be watching all your videos for sure! Keep up the great work.
thumbs up for your teachings. thank you , tusen takk.
You are really a very good teacher. Thank you and may god bless you!
Very nice and clear . Concepts are explained properly.
Great Video!
I've been writing VBA code, but I had always been confused about the definitions of methods, properties and functions. Thanks for clarifying
i enjoyed your tutorial,easy to follow and comprehend. Thanks for sharing.
Awesome bro. My first ever VBA lesson. Thanks .
this is too good and too easy to learn the vba coding and helpful for new comers
Superv Andrew. You are the best VBA trainer :-)
Awesome tute, Thanks. I bet your Salad Fingers impression is ace.
I am so grateful for this! I love the way that you teach,thank you so much! I subscribed!
A great tutorial on VBA. Thanks for sharing.
Your tutorial is marvelous,keep up the good work
Bought a book some time ago. Didn't make any progress with it. Examples were to singleminded. Made a lot of progress with your vids though. So thanks a lot! =)
Thank you Wise Owl..!!
Very informative introduction...!!!
Thank you verry much for the hard work to share your knowledge, you are my teacher and you are the best
Very well done. Excellento in a very sense of the word.
Hii Tq for detailed classes ..but I find the feature itelisense ..which shows scroll down for different methods ..do I need to add any settings for the drop down of methods
Wonderfully done. Looking forward to watching more.
Hi WiseOwl, which video will be most useful to use to create a script to combine one specific worksheet of multiple workbooks from one directory to an existing excel worksheet. The specific worksheet has the same layout as the existing excel worksheet. Thank you in advance voor your help.
This is absolutely fantastic! Cheers!
Very helpful tutorial and the material was very well presented. Thank you.
19:20
Hi there from America....Yeah sorry about that...we really butchered your language :p I've actually always wondered how those Yankees developed their own accents
Great tutorial. I have been writing formulas for a few years now and thought VBA would be too complex for me to learn. However, so far you're making it look possible for me. thx
Excellent teaching! Thanks. One question, when I hit Ctrl - Space, no anything showed in VBA editor. Could you please let me know how to enable that feature in my VBA? I am using Excel 2007. Thanks.
***** The problem got solved! Thank you very much for your answer!
Hello,
I have a question regarding the cell dimension. I have a master sheets (Sheet1) and I create multiple sheets sorted by a specific column located in the master Sheet1. How can I have the cell dimension in the other sheets as same as the cell dimension in master ?
thank you
Great video but for some reason I don't have the intellisense list for RGB colours, I am using Excel 2003
Awesome video clip. I really appreciate for the video clips that you uploaded. Is there any chance you will show tutorials such as Access VBA programming for beginner?
Its wonderfull......... nice way of teaching.. very helpful.. thanks to WiseOwlTutorials
Thank you WiseOwlTutorials for this informative video.
welcome to this wiseowl tutorial :). love it