Average Value Problem

Input up to 5 integers using an ending value of 999 to stop the inputting process, then find the average value of integers. Display the average integer value. Use a Do-Until loop  in the code to solve this problem.

Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdAverage. Place the code under the Click event of a command button titled “Average of Integers”.

 

Flowchart Solution

Sample Screen Shots

VBA Solution Code