Post a New Question


posted by on .

Option Explicit
Dim Answer
Dim aScores()
Dim intNumScores

' Initialize Answer so loop will enter and execute
Answer = vbOK
Do While Answer = vbOK

intNumScores = CInt(InputBox("How many scores will you be entering?", "Enter

Number Of Scores"))

ReDim aScores(intNumScores)
Dim ii
Dim sngSum
Dim Score

' Initialize the sum to 0
sngSum = 0
For ii = 0 To intNumScores -1
Score = InputBox("Enter Score #" & ii + 1, "Enter Score")
' If user just hit enter, exit.
If Score = "" Then
Exit For
End If

' Store value in array
aScores(ii) = CSng(Score)

' Add new value to the running sum
sngSum = sngSum + aScores(ii)

' If user entered a blank, exit
If Score = "" Then
Exit Do
End If

' Compute Average
Dim sngAvg
sngAvg = sngSum / intNumScores

Answer = MsgBox("The Average Score is: " & sngAvg & " Continue?", 65,



Please can you check for me?

  • Computer programming - ,

    Assistance needed.

    Please type your subject in the School Subject box. Any other words, including obscure abbreviations, are likely to delay responses from a teacher who knows that subject well.

Answer This Question

First Name:
School Subject:

Related Questions

More Related Questions

Post a New Question