Payroll Total Problem

Input  payroll amounts for all employees. Program should total the amounts until an ending value of 999 is entered. After the 999 has been entered display the total payroll amount to the screen. 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 cmdPayrollTotal. Place the code under the Click event of a command button titled “Total Payroll”.

Flowchart Solution

Sample Screen Shots

VBA Solution Code