Variable increase/decrease

Summary

An assignment statement, like sTotal = sTotal + sSales. Adds to a variable, then puts the result back in the variable.

Situation

You are accumulating a value, like a total, or count.

Needs

A variable to be increased/decreased, and a value to add or subtract.

Provides

A variable that has been increased/decreased.

Action

Use an assignment statement, with the variable to be changed on the left and on the right of the =.

Explanation

Usually you find these statements in a loop:

  • sTotal = 0
  • For sIndex = 1 to sNumberOfRecords
  •     sSale = rGoatSales.Cells(sIndex, 2)
  •     sTotal = sTotal + sSale
  • Next sIndex

Each time through the loop, another sales value is added.

Where referenced