Reference no: EM132892732
Automobile Ordering Project VBE
For this project, you will produce a VBE program to allow a customer to order a car. Your program will collect the customer name and phone number and determine the price of the car based on the options the customer selects.
There are three engine types from which the customer can only select one. There is a four-cylinder economy engine (priced at $15,000), a six-cylinder engine (priced at $20,000) and an eight-cylinder engine (priced at $25,000). One set of options for the car includes: upgraded leather interior ($1,250), a power package that includes power steering, windows, doors, etc. ($750), an upgraded music system ($500), a GPS navigation package ($2,000), remote start capability ($1,500) and all-wheel drive ($2,500). The user can select from zero to all of these.
There are three paint finish options from which the customer can only select one. There is a standard paint option (no additional cost for this), there is a two-tone option (priced at $2,000), and there is a metallic paint option (priced at $2,500).
The user should start with an Excel spreadsheet that only contains a single button. The user should click on that button which should pull up a form from which the user will choose their options. After the user has selected their options you should print out their car with only the options selected and the associated prices, along with a total price. You should store the customer name, phone number and total price either at the bottom of the spreadsheet or on a second sheet. Your output should look similar to the picture shown below depending on the options the customer chooses. All of the output shown in red/italics should be generated by your program based on the customer inputs.
You should NOT use any of Excel's functions. So don't use the 'Sum' function on the spreadsheet to total the customer's order, do that using VBE. Everything that shows up on the spreadsheet should be generated from the code you type. When you are finished, save your file with your last name, and save it as a 'macro enabled workbook' type, not an excel spreadsheet.