*Please Solve BOTH PROBLEMS with VBE in Microsoft Excel*

*Please provide the Entire code and the results in The Excel Workbook*

1. Create five variables: runners name, number of runs, number of miles ran, total miles ran, i. Using a loop, create input boxes to calculate total miles ran. Then, create a message box that states: [runners name] ran a total of [total miles ran] during the week. Within the brackets, variables should be used. Use the following input values when running the macro:

1. 1. runners name = Nancy Smith
   2. run #1 = 3.8 miles
   3. run #2 = 4.1 miles
   4. run #3 = 2.5 miles
2. Create a new, private, variable called: strName as a data type: string. Set this new variables value to your name. Then use an IF function: If strName = your name, create a message box that states: [Your Name] is the sales person. If not, have the message box state Error. (Hint: All string data points must be enclosed within double quotation marks.)