For-Next

Dog happiness

Body: 

Find average dog happiness, and the happiest and saddest dogs.

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)

Total-high-low

Body: 

Write a program to find the total, highest value, and lowest value of a data set.

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)

Indexes and loops are BFFs

Indexes and loops

Remember indexes? Use a variable to refer to another piece of data. For example:

Cells(row + 3, column + 2)

You've seen loops that change numbers, like this:

  1. Dim x As Integer
  2. x = 1
  3. Do
  4.     MsgBox "The square of " & x & " is " & x * x
  5.     x = x + 1
  6. Loop While x <= 5
Put them together.

Keywords: