Multiple choice technology

If you want a loop to run until it finds a specified value, what type of loop would you use?

  1. A For Each…Next loop.

  2. A Do...Loop.

  3. A Loop-dee-Loop.

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When you need to loop until finding a specified value, a Do...Loop is the appropriate choice. It allows you to continue iterating until a condition (like finding a target value) is met, using either Do Until value_found or Do While Not value_found. For Each...Next loops are designed for iterating through collections/arrays where you visit every element, not for stopping at a specific match. Option C is a nonsensical distractor.

Keep practicing — related questions