Question: Using the data file in excel called CARS. Excel sheet: https://drive.google.com/file/d/1QdWlJuk4JL1FqTkyhcrZSeKsNR6RdSEs/view Develop a form in VBA (VIsual Basic) that calculates and displays the results in

Using the data file in excel called CARS.

Excel sheet: https://drive.google.com/file/d/1QdWlJuk4JL1FqTkyhcrZSeKsNR6RdSEs/view

Develop a form in VBA (VIsual Basic) that calculates and displays the results in a "List BOX" of the following questions:

Using the data file in excel called CARS. Excel sheet: https://drive.google.com/file/d/1QdWlJuk4JL1FqTkyhcrZSeKsNR6RdSEs/view Develop

1) How many cars of 8 CLY cylinders, weigh more than 3600 WGT pounds and have an MPG less than 18.

2) List of ENG model engines, which are 4 cylinders and weigh less than 2200 pounds WGT.

3) Which is the best ENG engine model that has the highest MPG, lowest CYL cylinder and least WGT Weight in this table.

(need the code of each question in VBA excel)

You can use "Option button" or create a button by question, it is at your discretion. There must be a button to clean the list.

2 234705205 2 33222221222 2 L G 2 2 5 0 2 2 5 G3333344443 0 441112 88888888888888466644444468888444 858675444554544 8176545610019785 2 F 12345678911234567 8901 345678901 222222233

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!