Outcome of this Lesson

Select Case is a VERY USEFUL alternative to If … Then … Else when you have two or more options.

Use Select … Case … when you want to run one or more lines of code based on the result of checking a condition.

Any number of code statements can be put after each Case statement. They are all run if the Case is true.

Lesson 8 shows you three different examples:

• Select Case (Simple)
• Select Case with Text
• Select Case with Multiple Values

Download the workbook

After you watch the video, I recommend you open the example workbook.

And play around with declaring constants.

You can get the workbook at the beginning of Module 5 (Downloads).

Refer to the PDF Handout

For a handy summary of the key concepts, look at the Module 5 PDF Handout.

You can get the PDF Handout at the beginning of Module 5 (Downloads).

---

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]