Can someone help me with this? Please upload to dropbox and drop link. I keep getting it wrong :( language is VISUAL BASICS

PROGRAMMING ASSIGNMENT 3 INSTRUCTIONS Assignment 3 X Food Pantry How many hours Number of People 5 5 This week you are going to take your week 2 assignment further. The program will calculate the number of hours based off of the number of people and the hours entered. The program will display how many remaining hours the mission needs to be successful and the total number of hours. The program will do this using a combo box, listbox, sub, and a function. You are adding hours to the Food Pantry, You need a total of 50 hours You entered 25 You need 25 more hours to complete the mission a. h. A loop is created to receive the names of the people, through an input box, who are going to participate in the mission. The loop is a for loop and will cycle through the number of people entered. The names entered will be displayed. i. Make sure all spacing is accurate 4. Hours function a. Determine the hours required depending on the mission selection. You must show you can use a case statement for this decision. b. Return the hours required to a variable 5. Hours Met Sub a. Receives the number of remaining hours b. Checks to see if the number of hours were met or if there are remaining hours. A message is displayed to the listbox to state the number of hours remaining or if the hours for the mission have been met. 6. Close Button a. The application quits when the button is pressed 7. Clear Button The text boxes are cleared b. The labels are cleared The combo box is cleared d. The listbox is cleared Below are the missionaries signed up to help John Sally Sarah Nathan Audrey Clear Calculate Close e. f. a. C This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 3. Assignment 3 Mission Trips 1. How many hours Number of People a IstDisplay 1. Form Setup You must save your project using your initials in the name** This is required and the project will not be accepted otherwise. b. Design your screen to include all of the requirements below. An example of one design is found below. You can be creative. c. Update the backcolor to the color of your choice. d. Use appropriate naming conventions for controls and variables. Tab Control must flow in order and not go to the total textbox All buttons have access keys g. Lock the controls on the form. h. Choose 3 missions of your choice and include them in a combo box. You must enter three missions of your choice: i. Mission 1 11. Mission 2 111. Mission 3 Each mission will have a total number of hours required to complete the mission. These values are of your choice. 2. Code Create a comment section at the beginning of the code with the name of the assignment, purpose of the assignment, and your name. Comments must be throughout each sub of the application. b. Remove any subs that are not utilized by the program You must utilize a case statement to determine the hours needed for the mission and the decision must be in a function. d. You must create a sub to determine the hours met. 3. Calculate Button a. The information that was entered should be checked to make sure there are values entered. If the user entry contains null values, the user should be so advised, and the user should be directed to the text box that contains the error. Make sure your error messages are meaningful. Do not forget to verify the combo box. b. Clear the listbox before information is written to it. c. Store the amounts entered by the user in variables and use these variables in the formula. d. Determine the number of hours required for the mission selected. You will set the required number of hours for each mission. You must show you can use a case statement for this decision in a function. Save the number of hours required in one variable. Do not create a variable for each of the hours required. Calculate the remaining hours needed through the calculation below: (number of people) * (number of hours)) - hours required for mission f. Call a sub to display the remaining hours or if the hours have been filled. The sub will do the display to the list box. If the remaining hours is