Free Excel VBA Course #16 - SELECT CASE Statement in Excel VBA

In this video, I will show you how to use the SELECT CASE statement in Excel VBA.

Select Case is useful when you have three or more conditions that you want to check. You can also use this with two conditions (but I feel If Then Else is easier to use in those cases).

In this video, I take an example of student scores and how to assign them grades based on the scores.

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

-------------------------------------------------------------------------------------
0:00 - Introduction
0:41 - Declaring variables for VBA Select Case
1:30 - Basic VBA Select Case structure
2:56 - Testing our pass/fail code
3:37 - Creating a grading system with Select Case
4:24 - Using ranges in VBA Case statements
7:13 - Comparing VBA Select Case to IF statements
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial