Industrial engineering course (computer Application)

A popular exercise program includes a diet a plan. The plan requires users to take a quiz to determine the amount of calories they should ingest daily. The first question prompts the user to enter "1" if they are male or "2" if they are female. This is called the gender score. The second question prompts the user to enter their weight in pounds. Based on their weight, the following conversion chart is used to determine a weight score. The gender score and weight score are added together to determine an overall diet plan score. The following chart shows the conversion from a diet plan score to the amount of calories one should eat daily during the workout program. Write a user defined function in Excel VBA that requests the users to enter gender and weight (in pounds) information via Input box. Calculate their overall diet plan score and display the amount of calories they should eat daily via Msg box. Your function should be user friendly in a way that anybody off the street could easily use and understand it