Reference no: EM132909504
Create a Visual Basic program to work with the provided interface in an Excel spreadsheet. Use the same cell locations for your interface as shown in Figure 1. Do not forget to test your program to ensure it is working properly. (100 points).
Instructions for Preparing the Assignment Deliverables:
1. Visual Basic Code. Include a visual basic comment line near the top of your code that states your name. Copy this code into a Word document and include the document as a part of your deliverable on Canvas.
2. Excel File. Upload your Excel file containing the spreadsheet and VBA program. Create a "calculate button on your spreadsheet. (Make sure to save it as a macro-enabled Excel file - with extension .xslm!)
3. Calculation Results Shown in the User Interface. Type your name and the appropriate cell (B1). You will enter 5 different tour scenarios into your program, have your program calculate the answers, and print (to PDF) or take a screenshot of each scenario, paste them into a word document (properly label them) to turn in. The scenario information is as follows:
1. 24 people for 3 hours;
2. 55 people for 7 hours;
3. 62 people for 5 hours;
4. 95 people for 9 hours with an increase EHP set to 33% (a purposeful variation from the 25% rule);
5. 79 people for 6 hours with an EHP back to 25% but a LBP of $495 and SBP of $375.
After running the program to calculate the number of buses needed and the total price for each tour scenario, print (to PDF) or take a screenshot of the program's user interface. For example, start and run the program with the information of 22 tourists on a tour for 4 hours. Then, capture your results via print to PDF or a screenshot. Repeat this process using the other information sets, making changes to the pricing information when necessary.
Attachment:- Visual Basic program.rar