Question: ( 3 0 pts ) Write a VBA program that uses an array to solve the following problem. Given a positive integer n , find

(30 pts) Write a VBA program that uses an array to solve the following problem. Given a positive integer n, find the sum of all even number less than or equal to n. Display the sum in a messagebox.
Please ask user to enter a number, n.
Indicate that n must be greater than 10 and check it in your code using If q, End if structure.
Use Do While loop to iterate through numbers from 2 to n, incrementing by 2 in each iteration
Print all the integers to Excel Worksheet
Display the sum of even numbers in a message box.
Calculate average of all the numbers and enter them below minimum and maximum numbers on the worksheet
Provide all the necessary titles in your worksheet
 (30 pts) Write a VBA program that uses an array 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!