Question: I need help to solve these two question inVBA macros excel as soon as possible. .VBA macros Create a click event handler for this button



.VBA macros Create a click event handler for this button that does the following: 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. A C D E 1 G 2 3 4 5 + 7 co 10 11 Assignment Statements 12 13 14 15 16 Secondloop Third op Code Add-ins Controls XML endCount 1500 D E F G 1 2 startCount -250 currentCount -250 endcount 1500 3 4 5 6 7 Third Loop 8 9 10 11 12 13 15 16 Secondloop Thirdloop Assignment Statement FOTO Code Un Dialog Refresh Data Add-ins Controls startValue XML -1000 D E F G H startValue -1000 currentValue - 1000 endValue 5000 Second Loop 9 10 11 33 14 15 16 SecondLoop Thirdloop AssignmentStatement FourthLoop BE ET Type here to search O i .VBA macros Create a click event handler for this button that does the following: 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. A C D E 1 G 2 3 4 5 + 7 co 10 11 Assignment Statements 12 13 14 15 16 Secondloop Third op Code Add-ins Controls XML endCount 1500 D E F G 1 2 startCount -250 currentCount -250 endcount 1500 3 4 5 6 7 Third Loop 8 9 10 11 12 13 15 16 Secondloop Thirdloop Assignment Statement FOTO Code Un Dialog Refresh Data Add-ins Controls startValue XML -1000 D E F G H startValue -1000 currentValue - 1000 endValue 5000 Second Loop 9 10 11 33 14 15 16 SecondLoop Thirdloop AssignmentStatement FourthLoop BE ET Type here to search O
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
