B d D E F G H 1 Practice 7 2 Create a dynamic interface to allow users to elther search current scheduled travel or add new trips. 3 Application should be able to look up information or add new information. Should include error checking. 4 1 Question 5 6 #1: Allow user to either lookup trip information by employee name or add new trip information to table. 7 Ask user for menu option: 1 to lookup, 2 to add new. Make sure menu option is valid. 8 In Excel name starting cell for travel table and name entire location/cost table. In VBA, record range of entire 9 scheduled travel table (with labels). Ask user for employee name. 10 vf user wants to lookup info: check if employee name is in first column of travel table. If not, give error message. 11 Otherwise, lookup location, nights, and cost info and give user report message. 12 of user wants to add new trip: check if employee name is already in first column of travel table. 13 Hint:check If Not Range(). Find() is Nothing. If already scheduled, give error message. 14 otherwise, ask for new location and check that it is in first column of location/cost table. 15 Ask for number of nights and make sure positive number. Calculate total cost = travel cost + nights * $100ight. 16 Output new trip information to new row in table. Hint: Use with start range. End[x]Down) and Offset to new row. 17 18 Scheduled Travel 19 Employee Client Location Number of Nights Total Cost Client Location Travel Cost 20 F. Garcia Arlington 1 $562.50 Arlington $262.50 21 S. Tiago Arlington 4 $462.50 Atlanta $450.00 22 D. Edwards Baltimore 1 $675.00 Baltimore $375.00 23 J. Jones Arlington 2 $462.50 Charlotte $150.00 24 M. Jane DC 4 $700.00 DC $300.00 25 Richmond $187.50 26 27 28 Employee Travel 29 Lookup or Add New Trip 30 31 32 33 34 35 36 37 38