Excel VBA Introduction Part 13 - If Statements

By Andrew Gould

[maurocastagnera]

Dear Andrew, I understand more in 17.54 minutes of your video than on half a day of theory of if statements, even though now it's 23.45 p.m.! Thanks for your excellent work!

[Tat-cxlr]

Encore merci. Vous méritez un Oscar YT. Amicalement.

[Worldslargestipod]

Without a doubt the best VBA tutorial on the internet.

[maurocastagnera]

Dear Andrew, your Knowledge about VBA is EPIC! You are the best on the web! 👏👏👏

[maurocastagnera]

Now that I can better understand English language (even without subtitles), I'm covering your videos and I realize even more important details and I understand even more how smart you are and really an excellent teacher that every student should want to have ! Dear Andrew, you are really the best of all! 😊

[steinvanheirsele]

Give this guy a medal.... you're reducing my workload quit a bit.
grtz from Belgium

[maurocastagnera]

Simple and extremely clear, you can even easily explain things that seem complex. You have a great quality and that is to awake in those who are listening to an increasing interest in the subject you are dealing with. In a nutshell, learn the concepts even just for the joy and the taste of learning. Qualities that only the great teachers have! Thank you very much.

[daniellako]

I've never thought that I will spend my weekend wathcing VBA tutorial, but it happened thanks to your work. Excellent quality, clear explanations, very well done!

[maurocastagnera]

I can only say what was written in other comments, that is you are really the number one on the web for the VBA. I really appreciate your intelligence and your ability explaining things excellently! Thanks endless!

[amandafernandesramospasson]

awesome! you made VBA a lot easier for me. thank you so much.

[grzegorzdabrowski]

The best tutorials I've ever seen. I am trying to learn VBA some time by myself and after watching your movies (12 already) a lot of aspects of VBA is now clear  for me. Going to see all of them. Thanks a lot.

[manishmanhar]

Thank you so much for the tutorials. Your efforts are clearly visible.

[bcc]

This video is clearly EPIC. Great series of videos, very informative and easy to follow. Thanks!

[imtiazulhaque]

Your tutorial videos are very comprehensive and very helpful for a beginner like me to learn VBA and developing Macros in excel . Thanks

[djram]

Dear Sir Andrew. The tutorials are just just excellent. I have started learning at one go. In fact I have started developing a few applications useful to my daily work. Thank you very much for sharing the knowledge.

[therightflavour]

Hi Andrew

I am absolutely loving your tutorials. I am learning a lot more than I bargained for. I already have an educational background in programming so I am basically using your tutorials to refresh my memory of VBA. I spiced up the code a bit including all that I have learned from your previous videos.

Sub TestingFilmLength()

Dim FilmLength As Integer
Dim FilmDescription As String
Dim FilmNameAddress As Range

Set FilmNameAddress = The Film Name", Type:=8)
FilmLength = FilmNameAddress.Offset(0, 2).Value

If FilmLength < 100 Or Len(FilmNameAddress.Value) < 10 Then
FilmDescription = "Short"
Else
If FilmLength < 120 And Len(FilmNameAddress.Value) < 15 Then
FilmDescription = "Medium"
Else
FilmDescription = "Epic"
End If

End If

MsgBox FilmNameAddress.Value & " is " & FilmDescription

End Sub

[bodacachanilla]

The way you convey the information is excellent!!  I found this very useful.

[nareshful]

initially i did had bit of confusion to combine inputbox and if, but when i went back to revised variable video, I resolved it. Followings are my learning

[portapere]

Very nice tutorials Andrew. Thanks a lot from Barcelona. Practical and sistemathic. Just great :))

[SearchKnowledge]

Another well explained tutorial, God bless you.