Excel VBA Introduction Part 14 - Select Case Statements

By Andrew Gould

[cavinoginga]

I reiterate here that you have changed my life. Your tutorials are great and this is ten times more valuable than attending a class. You are super audible, organized and a predistined lecturer from birth. Kudos to Wise Owl!

[maurocastagnera]

The best VBA guide you can find on the web and Andy Gould the best teacher I've ever seen! The world should be grateful for your immense knowledge of the subject and admirable generosity in making it available to the community. England must be proud of you! Chapeau 👏👏👏

[joaoramos]

Andy. You have changed my status in the company i´m working for. Due to your tutorials i became very proficient in VBA and today I develop Excel files running with VBA programming

[jackeroo]

Andrew by far is the most effective vba teacher ever!

[AspullSpasandPools]

Hi WiseOwelTutorials my name is Ian Ferguson I have been playing with VB for some time,  
but have learnt more with your tutorials in a short time. Just wanted to thank you so much 
Your tutorials are fantastic very informative.

[tomaskochan]

Hi, I agree with everyone who says your tutorials are among the best!

[SamHopperton]

Loving these tutorials, Andy. They're very comprehensive and easy to follow. I had no knowledge of VBA prior to these videos and I'm only 3 days in and already applying techniques to my own projects. Great work!

[DJResourceTV]

Hard to believe your video's only have 15k views (this one has), they deserve so much more !!!

They are very clear in terms of workflow, spoken and articulated properly and easy to understand. Sometimes your as accurate as a book in terms of definitions and ways to describe features etc. (that's a complement ;))
I can assume a lot of people (like me) have a lot of help by them in understanding the way VBA and Macros work. They for sure helped me in getting started and tickeling my curiosity in regards to learning more about VBA !

Keep up the good work and let more films come online :)

[jicbs]

Andrew,
Thank you so much for sharing your knowledge. Watching the “other guys” has been beneficial, but your concise explanations of syntax and structure make sense. Thanks for keeping it simple!
Jimmy

[ThousanWhite]

Your tutorials are gonna get me a job!

[engenheiromalucoo.o]

Best ever! If you likes please consider donation to help his project.

[leeuwtjevanjuda]

Excelent Tutorials WiseOwl. Very clear!

[UmamaheshwarAskula]

Hi, These videos are really helpful to understand VBA. Thank you.

[toyboxcheetah]

Clear explanation with good examples. thanks!

[stevestackman]

Case statements versus If statements. Why would you choose to use one over the other? They seem to do basically the same thing. Is there a time or reason to use a case statement instead of an If statement?

[natashacamille]

Hi - I have been going through these WiseOwl videos, and they are beyond amazing, I plan to go through all 39 of them (Have gone through 1 to 14 till now) - since I am a beginner to VBA what I really wanted to know was - after going through these 39 videos would I just get an introduction to VBA or would I have a good summary of what VBA can do and how to do it? The reason I was asking this is, if I want to do a course on VBA after going through these 39 videos (and some practice) - should I do an advanced VBA or an intermediate VBA course? THANK YOU TO ANYONE WHO CAN REPLY TO THIS

[Manche-De-Pelle]

Dear ANdrew, what happens with the 14.2 video with the switch function ? I see that it's not in the introduction formation. Also I would like to give you a little tip but on your website, I can't give with paypal, is there any way to send you little something with that platform ??? Thanks again, you're the best teacher that I ever had !!!

[gurupranesh]

I am not able to get the output if I use the application.inputbox instead of the range("A3") in the code. Can u please help me out??

[caezar]

Hi Andrew. Thanks for these videos, very useful. I didnt catch from your videos any comparison of if statements vs select case, ie are they exactly equivalent or is there any advantage to using one vs the other?  

[craigdcorrea]

Hey these videos are really awesome!!! I have a doubt though!!! I want to export my mail from outlook to excel!!!! I am new to vba and have only gone through all your videos!!!! is there any chance a tutorial can be made on the same???