Question: Write a VBA script, that will ask the user to enter a number. The program will keep asking the user to enter a number until

Write a VBA script, that will ask the user to enter a number. The program will keep asking the user to enter a number until the user enters 0. When the user enters a 0, the program will display a message of how many numbers the user entered before the 0. For example, if the user enters 1,2,3,0. The program will display You entered 3 numbers. Also, create a macro button for it in Data sheet (at the bottom) so that it is easier to re-run the macro. HINT: this is similar to the password program we did in class

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!

In a redhat linux distro Write a shell script that will ask a user to enter a number ( MAX _ STUDENTS ) Check the value of MAX _ STUDENTS variable inside your script. If the value is more than 2 5 ,...

I have a homework assignement that has 4 parts. Part 1 is asking to Sum total: 1 . Create a new method for adding together two numbers. This method returns void and take no parameters 2 . use a Do -...

C++ Assignment (Please post the solution and the output) /* Please submit this program in pseudocode */ Requires: Variables, data types, and numerical operators, basic input/output, logic (if...

nput loop - 30 points Creating a list - 10 points Print out the list - 10 points Prompt user for new string - 10 points Add new string to list - 10 points Make new tuple and print - 20 points...

1) Write the XHTML code for a short Web page. Include the following along with the usual HTML and BODY tags. You can use whatever hyperlinks and image URLs you want. (other than distasteful sites,...

Question 4 (1 point) int x = 0; while (x > 10) { cout x++; } What is the last thing printed by the above code? Question 4 options: 8 9 10 11 Nothing is printed The code never ends Save Question 5 (1...

Question 1 (1 point) int x = 0; while (x x++; cout } What is the first thing printed by the above code? Question 1 options: -1 0 1 2 Nothing is printed Save Question 2 (1 point) int x; for (x = 0; x...

Can someone explain why my answer is not correct. Thanks! Question 15 0/0.32 pts If you need to write a do-while loop that will ask the user to enter a number between 2 and 5 inclusive, and will keep...

Write a java program that will ask the user to enter the number of sides and lenght of sides of a sign then user will enter a string they prefer on the sign. program will calculate area in square...

write a program recives from user sentence (by cin.getline(sentence,N) (const int N=1000) after this ask from user to enter random number the program should devide the sentence for parts by the...

First National Bank reports the following items on its balance sheet: cash, $200 million; U.S. government securities, $150 million; residential real estate loans, $300 million; and corporate loans,...

Presented below are four statements which you are to identify as true or false. If false, explain why the statement is false. 1. The objective of financial statements emphasizes a stewardship...

How long does a licensee have to respond to a writing ( i . e . letter or email ) from the TSBPA requesting a response? within 3 0 days or less as specified by the Board within 9 0 days or less as...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...