Question: The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are
The following Excel image has a VBA program (see below). What will be the result after the program is executed? Any cells not displayed are currently empty, and any cells with numbers are formatted numeric.
| Sub TWS() |
| a = 0 |
| i = 15 |
| Do While i >= 13 |
| a = a + Cells(i - 6, 2).Value |
| i = i - 1 |
| Loop |
| MsgBox A, , "The Total " |
| End Sub |
10
0
20
30
The program is incorrect-will not run
A B C D 1 Total Widgets Sold (TWS) - 1st Quarter 2 3 Name January February March 4 Abe 10 100 1,000 5 Bells 10 100 1,000 6 Charles 10 100 1,000 7 8 David 10 100 1,000 9 Frank 10 100 1,000 10 11 Harold 10 100 1,000 12 lan 10 100 1,000 13 Jared 10 100 1,000 14 Lila 10 100 1,000 15 Matthew 10 100 1,000 16 Total 100 1,000 10,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
