Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Databases Concepts And Practice

Authors: Suzanne W Dietrich

1st Edition

1119827949, 9781119827948

More Books

Students also viewed these Databases questions