Question: 1. Write a VBA programx using a do .. while loop, that displays all the multiples of 5 in the range between 1 and 365

1. Write a VBA programx using a do .. while loop,

1. Write a VBA programx using a do .. while loop, that displays all the multiples of 5 in the range between 1 and 365 in "Sheet2", column A, starting from cell A1 lI 2. Write a VBA program that uses a do until loop to calculate the following summation: sum=2+4+5+ + 100 The result is displayed in a message box. PAGE 1 OF 1 73 WORDS 6:28 PM 11/14/2017

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:

1. Write a VBA macro called EVEN100 that use a loop and displays all the even numbers in the range of [100,300] in "Sheet1", column C, starting from cell "C1". 2. Write a VBA macro called SUM31 that...

Q:

I need help. with tis homework Jial Handout #3 - CSCI 2440 01 - Review the enclosed screenshots and familiarize yourself with the source code of the file bingo- skeleton.htm. Using embedded CSS,...

Q:

Write an excel code that shows if the student pass or fail, note that if the student got 60 or more in at least 2 exams then the student passed and write pass, if not write fail (1) Write VBA...

Q:

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Q:

01 Review the enclosed screenshots and familiarize yourself with the source code of the file bingo-skeleton.htm. Using embedded CSS, modify the various body, table and other tag properties in...

Q:

01 Review the enclosed screenshots and familiarize yourself with the source code of the file bingo-skeleton.htm. Using embedded CSS, modify the various body, table and other tag properties in...

Q:

01 Review the enclosed screenshots and familiarize yourself with the source code of the file bingo-skeleton.htm. Using embedded CSS, modify the various body, table and other tag properties in...

Q:

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

Q:

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

Q:

unit II q12. Summarized on the right is the sale (in thousands) of the top five products in 2002. Use this information to calculate what percent of the sales of these five products was due to product...

Q:

1. Distinguish between installment credit and open-ended credit. 2. Explain the basic features of revolving credit. 3. Describe how someone might use a personal line of credit.

Q:

The standard material cost for a normal mix of one tonne of Urea fertilizer is based on Chemical A B C During Usage (kg.) 240 400 640 Price per kg. 6 12 10 a month, 6.25 tonne of Urea were produced...

Q:

1 . Analyze the company s long - term assets and general ledger records for accuracy . 2 . Outline the company s strategy for managing its long - term assets. 3 . Identify appropriate depreciation...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

2. How do they influence my actions?

Q:

4. Is your choice different from that which you would recommend to Laura?

Q:

5. If yes, then why?