Question: IN VISUAL BASIC, CREATE MACRO To create a macro to count and show the number of sales larger than 100. Please find detailed instructions below.

IN VISUAL BASIC, CREATE MACRO

To create a macro to count and show the number of sales larger than 100. Please find detailed instructions below.

Descriptions and requirements:

  1. The data contain sales of 1,000 products in 60 different days. Each cell corresponds to the sales of a product (row) on a particular date (column).
  2. Do not use macro recorder to create the macro.
  3. Create a single Sub procedure for the purpose. Use a message box (MsgBox in VBA) to display the following information (the number) cells in the Sales range have a quantity larger than 100.

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!