Question: PLEASE USE VBA EXCEL AND OPTION EXPLICIT Exercise: Clown catapult Youve kidnapped clowns to use as ammunition for your clownapult. Write a program that will

PLEASE USE VBA EXCEL AND OPTION EXPLICIT

Exercise: Clown catapult

Youve kidnapped clowns to use as ammunition for your clownapult.

PLEASE USE VBA EXCEL AND OPTION EXPLICIT Exercise: Clown catapult Youve kidnapped

Write a program that will scan through clown data, and identify clowns that meet the users criteria.

Heres a sample:

clowns to use as ammunition for your clownapult. Write a program that

The user types in criteria for weight and shoe size, and clicks Run. The program highlights clowns that meet the criteria by setting the background color of their id and name cells to yellow. Clowns that do not meet the criteria are set to white. Clowns must meet all criteria to be selected.

Assume that the user makes no mistakes when typing in the data. Assume there are no errors in the clown data.

The program also shows some statistics. The overall clown count is the total number of clowns in the data set. You dont need to round the averages.

Heres another example:

will scan through clown data, and identify clowns that meet the users

A clown that was marked in yellow for one run, might be marked in white the next time. So, you need to explicitly set the cell color for each clown to yellow or white.

If no clowns meet the criteria, you wont able to calculate the average. In that case, show messages instead:

criteria. Heres a sample: The user types in criteria for weight and

Dont start from scratch. Download and use the starting workbook that has been created for you.

The usual coding standards apply.

Hint: Declare variables for totaling as Longs, rather than Integers. The starting workbook has those declarations for you.

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!

Write A Subscript/ Macro That Calls Either Subscripts, Functions, Or Both That Takes Two Values As Inputs (From Either The Spreadsheet, The User Through Input Boxes, Or Hardcoded Into The Subscript)...

Please use VBA (excel) 3. For the offset slider crank mechanism in Fig.3, (a) develop a computer program that can determine the position of all links for crank angles that range from 0 to 360. The...

With Excel VBA, create a sub call "ListofRivers" to perform following tasks Please use VBA and screenshot the code ' Load the data in the USA_rivers.csv into Worksheet 'ListofRivers'. The load should...

Please help me with the following VBA programming project questions, I hope to get a correct answer as a reference, thank you very much. a x 2 + b x + c = 0 D = CoefficientB * CoefficientB - 4 *...

Excel VBA project, Please explain the code you wrote and all the steps one by one. Thank You! please use vba..

Write a macro that processes the following sales data (your final code should work with data that have any number of products, different number of price breaks, different quantities for a price...

Please Follow the instructions, and use VBA excel. Thank you :) Second exercise. In this exercise you will learn the use of range names. This will make only a small change to the worksheet that you...

Write the VBA code to do the following: Create a 10*10 times tables grid, and store the results in an array. Allow the user to enter in two numbers, e.g. 3 and 5, and return the number stored in...

Please provide VBA Excel Codes. So that there should not be any abuse/inappropriate complaints or conflicts.Thanks. Write a macro that processes the following sales data (your final code should work...

In the Mini-Case Learning by Drilling, an oil drilling firms average cost when working with production company M depends partly on its own cumulative drilling experience, N, and partly on the...

List the four parts of the human resources management process.

Vera gives Will a $ 5 0 0 check as payment for a debt. Will crudely increases the amount of the check to $ 5 , 0 0 0 and deposits the check in his First Bank account. Vera is liable for the payment...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. What might you have done differently

4. Did you rethink your decision?

3. Did you seek anyones advice?