Going Looopy trying to get data from a Form!

We've already seen how powerful repitition can be for us programmers... to jog your memory again, open up the AJLogo Turtle Graphics Application in another browser window (remember, right-click then Open in new window). See if you can remember how to create a function called flower! (Hints: you might want to first make a function called square, and then use the repeat command to make your flower function).

We're going to use repitition in a similar way to enter new information from a form into our spreadsheet! Our problem is that everytime we press OK on our form, the information gets entered onto our spreadsheet on exactly the same row! How can we get around this? We'll work out a solution in class together! This'll also give us a chance to find out what the VBA debugger is :)

Once we've got our solution working for our HardwareParts application, we'll close this worksheet and test our solution on our StudentRecords application. Now we're ready to start our first assignment!

To recap some of the ideas we've been learning (and learn a few more!) check out the excellent tutorial provided by Microsoft called Get in the Loop with Excel Macros.