Question: *Please Solve PROBLEM with VBE in Microsoft Excel* *Please provide the Entire code and the results in The Excel Workbook* Create five variables: runners name,

*Please Solve PROBLEM 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. runners name = Nancy Smith
  2. run #1 = 3.8 miles
  3. run #2 = 4.1 miles
  4. run #3 = 2.5 miles

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Systems Analysis and Design All questions in the work are about a real world system development case. Please read it carefully before you start the exam. all questions are asked at the end answer one...

Q:

I want to know how all the numbers are going and which ones are specific to organize them by cell 00 Estilos de celda v Formato y filtrar seleccionar datos G14 X V fx A B C D E F G H K L M N O Smith...

Q:

*Please Solve BOTH PROBLEMS with VBE in Microsoft Excel* *Please provide the Entire code and the results in The Excel Workbook* Create five variables: runners name, number of runs, number of miles...

Q:

So I can make the flowchart but not sure how to make the VBA code. It's all super foreign to me 13.5 VBA Project: Olympus Tours You have just been hired by Olympus Tours (OT), a bus rental company...

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

Q:

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Q:

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Q:

1.2 Rewrite the chemical formulas in Table 1.7 into simplified crystal-chemical formulas of spinel.

Q:

Write the coordinates of the points A, B, C, D, E, F, G, and H marked in the diagram below. Y axis Xaxis -4-3-2- 2 3 4 5

Q:

an employee who communicates effectively is likely to 1 . be highly compensated 2 . do their job well 3 . be finacially savvy 4 . be well educated

Q:

[ In this section, describe the responsibilities of a financial analyst. Write five to seven bullet points outlining the responsibilities a financial analyst has. Use complete sentences. ] [...