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:
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 222222233Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started