March 8, 2021
Hot Topics:

Spot the Loop

  • By Karl Moore
  • Send Email »
  • More Articles »

Don't look at me, but there's a loop on the loose. In this section, we're going to look at two things - firstly, how to create a "loop" in code and secondly, how to get information from the user.

Karl explain loops!

Loops are amazingly useful. For instance, you may want to display a message box for every single student in your highly successful grammar school. You can do this two ways - either manually code every single message box (highly inefficient, goes against all coding practices and not very tech-savvy) or use a loop that says, in English, "display a message box for every student".

Creating a loop is pretty simple. Let's look at a sample piece of code

For i = 1 to 5Msgbox "I have looped round " & i & " times"Next i

I'll explain what's happening here.

The first line tells Visual Basic how many times it should loop around. It's saying - loop around this bit of code five times and store the number of times it has looped around in "i". The second line is just a simple message box we display that shows "i" - don't forget, "i" is just the number of times it has looped around. The third line, "Next i" just tells it to go back to the beginning until it's gone from one to five.

Phew! That's a lot to take in. But don't worry - you can do it!

Just think of what you could use this for! You could say to Visual Basic - loop through all the students in our school database and add them to a box on the screen.

Page 2 of 7

This article was originally published on November 5, 2002

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date