Download the Olympus Tours Programming Project Worksheet below. Do not make your own workbook. Add VBA code to complete the project. Your VBA code should work with the cells that are already positioned on the [User Form] tab of the workbook. Do not change the cell locations or layout on the [User Form] tabwithin the workbook. In addition, donotadd or delete any columns or rows. Use VBA to do all of the calculations. Do not use spreadsheet functions. Add your VBA code to the two existing subroutines that have been started in Module1 already within the workbook. Add your code to the subroutine namedEstSingle()that will run when the user presses theRun SingleButton. Add your code to the subroutine namedEstBatch()that will run when the user presses theRun BatchButton. Connect the appropriate subroutine to the respective buttons, so that the correct subroutine will run when the button is pushed. In your code, use the Option Explicit setting for both subroutines. (This should already be set.) Verify this by ensuring that the first line of code says “Option Explicit.” Use Dim statements to declare all variables that you use in your code.Declare the variables as the data types shown on Column D of the [User Form] tab. However, if this results in an overflow error, you are welcome to use the Variant variable type. This erroneous overflow error is due to some internal VBA issue that Microsoft has not yet fixed in some versions of Excel. Test your program with a variety of inputs to ensure it works properly before you turn in your assignment. You do not need to calculate PPBR or EHP. Rather, your sub should take whatever values of PPBR and EHP areprovided by the user in the setup variables section in the single estimate user form. Upload your completed Excel workbook in the appropriate upload box below. Do not forget to handle user inputs that are invalid (i.e., 120 passengers) for single-trip estimates as indicated in the description above. Be sure your batch Sub can handle extra batches of data (same format as existing batches) added to the bottom of the batch input tab. Be sure your batch Sub can handle extra spaces (1 or more empty rows)between batches of data. Please comment your code so that it is easy for a grader to follow. Code without comments may be penalized. Partial credit is also much easier to grant if there are comments in the code.

Download the Olympus Tours Programming Project Worksheet below. Do not make your own workbook. Add VBA code to complete the project. Your VBA code should work with the cells that are already...

Oct 21, 2021