Excel Interactive Userform Design

Job ID: 40318030

Budget: €8 – €30 EUR

Instructions

1 - In sheet "Userform" : design a scroll bar, a dropdown list, a button and dynamic picture over the dedicated frames
a - The scrollbar will allow you to choose a number of days from 1 to 15 - This number must be displayed in the white cell "B18"
b- The dropdown list (combobox) will allow you to select an engineer from the list in sheet "Data" and must display the first name, a space and the last name
c - The picture of the selected engineer (available in sheet "Data" as well) must be displayed in the dedicated frame

2 - Using the daily wage of the selected engineer and the number of booked days, write a formula in the cell "I18" that will calculate the total cost for the booking

3 - Hide the cells outside the userform ( delimited by the colored cells)

4 - Insert any kind of button over the button frame and create a macro that will proceed the following : When clicking on the button, it must record on sheet "Records" the choices you have made on the interface :
Everytime you click on it, it must add a row to the table ( pink cells) with the date of the booking (you get it from a function today() ), the number of days, the name of the selected engineer and the total cost

5 - Protect Sheet "Userform" from any change except the one that are made through the controls ( the controls must remain usable)