Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 Product Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 240 127 156 89 137 145 153 247 246 124 17 113 105 172 132 246 174
1 Product Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 240 127 156 89 137 145 153 247 246 124 17 113 105 172 132 246 174 116 221 2 42 115 91 70 4 101 93 170 123 57 72 164 87 118 78 The data in the chart above contains sales of 7 products (row) in 6 different days (column). Each cell corresponds to the sales of a product (row) on a particular date (column) Create a single sub procedure in Microsoft Excel VBA to count and show the number of sales larger than 100. Use 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started