Excel 2010 VBA Tutorial 15 - Nested IF Statements

How to use nested IF statement to further control the flow of your program

[colina]

Another great video.  I like how Nested If statements are handled in VBA- it's so much cleaner than an Excel formula with one long line which can be almost unintelligible.  

[raheelali]

i want to thank you again for posting such videos. Its helpful.

[naveenk]

Thanks for the videos so far... Is it possible for you to create a video for nested collection in vba?

[fermgg]

i learned a lot from this video... do you have a package of all your vba videos so that i may be able to get a copy of these at once...instead of downloading one by one?....

[tomvonheill]

lol'd at that "wouldn't be flattered if they guessed i was eight" joke m8, thanks

[sebastienoguey]

Hey, love the series, quick question: How could I check that the data entered in the inputbox is numeric and so warn the user and exit the procedure before a data type mismatch error is generated? I figure I could do it with an error handler but I was wondering if there was a way of performing some sort of check on what the user is entering in the inputbox.
Thanks again for the series and all the effort you've put into it!

[minexcelu]

Hi, im really enjoying your videos :) One quick question, why won't the program run correctly if I changed the first two lines from "As Long" to "As String"?

[raheelali]

Hi Quick Question. With the nested IF we did not set condition for Guess < age and for guess  age. Still it works out all three possibilities.

the if/else combination always workout the 3 possibilitues if conditions are not defined ?

[GiDoRu]

hey,
for sure it's me again, your hard working student from moers, germany ; )
if have a question going further with this program. I would like it to be like this that if the guess is wrong that he asks again until the guess is correct. Is this somehow possible? I mean that the programm runs the if loop until it finally reaches the correct answer?
Best GiDoRu

[christopherbenton]

Just starting out and having a hard time understanding the hierarchy of procedures.In other words, how the hell can I use an If statement to  do something other than an obsolete msgbox. For instance, If answer = E then **what code can I put here to say fill selected sell with red" If answer = R then **code for fill selection with green** Else selection = no fill? Somebody HELP!?!?!