Question: I need help to solve it please with explanation as soon as possible. i have to the VBA on the excel. i should use the

I need help to solve it please with explanation as soon as possible.  I need help to solve it please with explanation as soon
as possible. i have to the VBA on the excel. i should
use the Vba on excel. changes the value of targetCellone to equal
i have to the VBA on the excel.
i should use the Vba on excel.

changes the value of targetCellone to equal one-fifth the sum of the value in the cell named startValue on sheet SecondLoop and the value of the cell named endcount on sheet Thirdloop. Changes the value of targetCellTwo to equal the average of the value in the cell named endvalue on sheet Secondloop and the value of the cell named endCount on sheet Thirdloop Create Activate and Deactivate event handlers for the sheet named AssignmentStatements. In the Activate Event, set the values of cells targetCellone and targetCellTwo to o. . In the Deactivate event handler, create a message box that says "Goodbye" EN View Code the Relative References Visual Macros Basic A Macro Security Code Add Excel COM ins Add-ins Add-ins Insert Design Mode Source Expansion Packs Esport Refresh Date Run Dialog Add-ins Controls XML StartValue -1000 D F G H 2 startValue -1000 currentValue -1000 endValue 5000 Second op 7 8 9 10 11 13 Secondo AssignmentStatement Fourthop Type here E ins Add-ins Add-ins Source Code Mode eRun Dialog Controls Refresh Data Add-ins endcount XMI 1500 D E F H 2 B startCount -250 currentCount -250 endcount 1500 4 5 6 7 8 Third Loop 10 12 15 16 Secondo op Thirdloop AssignmentStatement FourthLoop TO changes the value of targetCellone to equal one-fifth the sum of the value in the cell named startValue on sheet SecondLoop and the value of the cell named endcount on sheet Thirdloop. Changes the value of targetCellTwo to equal the average of the value in the cell named endvalue on sheet Secondloop and the value of the cell named endCount on sheet Thirdloop Create Activate and Deactivate event handlers for the sheet named AssignmentStatements. In the Activate Event, set the values of cells targetCellone and targetCellTwo to o. . In the Deactivate event handler, create a message box that says "Goodbye" EN View Code the Relative References Visual Macros Basic A Macro Security Code Add Excel COM ins Add-ins Add-ins Insert Design Mode Source Expansion Packs Esport Refresh Date Run Dialog Add-ins Controls XML StartValue -1000 D F G H 2 startValue -1000 currentValue -1000 endValue 5000 Second op 7 8 9 10 11 13 Secondo AssignmentStatement Fourthop Type here E ins Add-ins Add-ins Source Code Mode eRun Dialog Controls Refresh Data Add-ins endcount XMI 1500 D E F H 2 B startCount -250 currentCount -250 endcount 1500 4 5 6 7 8 Third Loop 10 12 15 16 Secondo op Thirdloop AssignmentStatement FourthLoop TO

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!