Question: Using VBA in Excel, write a sub in a MODULE that will ask the user for a distance. The only answers that are acceptable are

  1. Using VBA in Excel, write a sub in a MODULE that will ask the user for a distance. The only answers that are acceptable are 5000, 3000, 1000 and 500. Keep asking the user for one of these four values until a valid response is given BUT do not crash if an invalid entry is given. Repeat the value given in a message box.

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 Databases Questions!

Q:

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

Q:

Really the first pic is all you need. I provided all the numbers and I know theyre a little blurry bur for the most part you can make them out and know if theyre big or small. Please please please...

Q:

Make sure to add the code lines for the VBA please This assignment can be worked either as a team (two students per team) or individually. Prepare your answers in one Excel file, and submit your file...

Q:

How do you get $5145 cash balance? How do you do the bank reconciliation? Which journal entries must be adjusted? I have attached the assignment part B and my excel general journal (no need to use...

Q:

please answers i want to verify my answers. please see attached file Value Added Accounting Practices in Strategic Business Decisions Case 4 Fall 2016 Names Section: Points: Case 3.1 - 40 points Case...

Q:

Final Project 50pts (2) Criteria Ratings Pts Accounting Accuracy 20 to >18.0 pts 18 to >13.0 pts Proficient Competent Financial statements and ratios Most of the financial are completely accurate AND...

Q:

Student Instructions: The general objective of this activity is to developed proficiency in the Microsoft Excel spreadsheet, to calculate some variable costs, fixed costs, and total costs. Also, to...

Q:

Chapter 4Exercises 5, 8, 12, 17, and18 Problem 12 172 iStockphoto Variable Costing In 2012, the all-tube amplifier p r o d u ce d b y C l a u s e n Tu b e r e ce i ve d rave reviews and the company...

Q:

ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND STANDARD COSTS PER UNIT ARE UNCHANGED FROM THE PREVIOUS PERIOD AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO...

Q:

Good evening I need Part 2 of this assignment Task 1, Task 2 and Task 3 all complete with step by step calculations and answers to the problem.I need help in 12 hours deadline please thank you....

Q:

(a) Ideal formulas for the electrodes of the Li+-ion battery described in the chapter opener are C6Li (FM 79.01) and LiCoO2 (FM 97.87). When the battery operates, C6Li is consumed and LiCoO2 is...

Q:

After reading the article, briefly summarize the key points, concepts, strategies, lessons learned, etc. What did you learn about yourself after reading this article? What did you learn about human...

Q:

What is the formula to calculate per unit cost in a process costing system? total units produced total expenses incurred in process total units produced x total expenses incurred in process total...

Q:

Question 2 4 The success rate of the EEOC in litigation has been consistently at least 1 0 0 % 9 0 % 1 0 % 2 5 %

Q:

How confident are you about the level of your numerical/statistical competence? What development activities would help enhance this?

Q:

How well do you understand the advantages and limitations of different sampling techniques in relation to your project? What information or support might help you to develop your understanding and...

Q:

How well do you understand the implications of different question structures for subsequent analysis of the data? Who can help you with this decision-making process?