Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started