Hi I really need help with a project I am doing. I got super confused on the very last part can anyone look at this and tell me what it means? OR could I send you the project which has all the information and would be far more clear?
Modify the existing code in FlagQuotas accordingly to increment a counter variable for each ticket
holder, but only when one of their cell values has been flagged as being greater than or equal to a
quota. Note that comments have been included in the sub procedure to assist you in knowing
where to insert your code and advice on how to handle the processes. Each comment begins with
"PROJECT 3 HINT…". Also, this workflow should be followed:
• Integrate proper indenting of all statements.
• Modify the existing comments to include your name and code creation date.
• Declare 4 new Integer variables, suitably named (i.e. prefix each variable with "int").
• Next, incorporate the VBA code to increment each of these 4 variables at the right time (i.e. when
the quota has been met or exceeded). This would involve creating a Select Case statement that
determines which ticket holder column the active cell is in, and then update his/her variable.
• Once the For…Next loop completes, set each of the "Total MBE" cells (D16:G16) with its
matching variable value. Here's an example (note that sample data is shown; your values may
vary) of what Section 4 looks like after the above logic has been implemented (9 for Jack M., 6
for Natalie C., etc…)…
Page 6 of 7
3. Modify the MsgBox statement that ends the sub procedure to include the total count of MBE values.
For example, if Jack M. had 9, Natalie C. had 6, Anna M. had 5, and Bob T. had 5, the message box
would be display…
4. Test/debug your VBA code to ensure correctness. Click the "Evaluate Ticket Quotas" button to
perform your test. This button is already assigned to a macro that will assign new values to the
worksheet and call the FlagQuotas sub procedure.
5. Make sure the worksheets are in the following order (left to right):
• Section 1
• Section 2
• Section 3
• Section 4
6. Activate the "Section 1" worksheet.
7. Make A1 the active cell and ensure the Normal view is selected.
8. Repeat this process for all worksheets.
9. Activate the "Section 1" worksheet.
10. Re-save the file using the default name.
Modify the existing code in FlagQuotas accordingly to increment a counter variable for each ticket
holder, but only when one of their cell values has been flagged as being greater than or equal to a
quota. Note that comments have been included in the sub procedure to assist you in knowing
where to insert your code and advice on how to handle the processes. Each comment begins with
"PROJECT 3 HINT…". Also, this workflow should be followed:
• Integrate proper indenting of all statements.
• Modify the existing comments to include your name and code creation date.
• Declare 4 new Integer variables, suitably named (i.e. prefix each variable with "int").
• Next, incorporate the VBA code to increment each of these 4 variables at the right time (i.e. when
the quota has been met or exceeded). This would involve creating a Select Case statement that
determines which ticket holder column the active cell is in, and then update his/her variable.
• Once the For…Next loop completes, set each of the "Total MBE" cells (D16:G16) with its
matching variable value. Here's an example (note that sample data is shown; your values may
vary) of what Section 4 looks like after the above logic has been implemented (9 for Jack M., 6
for Natalie C., etc…)…
Page 6 of 7
3. Modify the MsgBox statement that ends the sub procedure to include the total count of MBE values.
For example, if Jack M. had 9, Natalie C. had 6, Anna M. had 5, and Bob T. had 5, the message box
would be display…
4. Test/debug your VBA code to ensure correctness. Click the "Evaluate Ticket Quotas" button to
perform your test. This button is already assigned to a macro that will assign new values to the
worksheet and call the FlagQuotas sub procedure.
5. Make sure the worksheets are in the following order (left to right):
• Section 1
• Section 2
• Section 3
• Section 4
6. Activate the "Section 1" worksheet.
7. Make A1 the active cell and ensure the Normal view is selected.
8. Repeat this process for all worksheets.
9. Activate the "Section 1" worksheet.
10. Re-save the file using the default name.
/www.tomshardware.com/forum/244553-49-read-programming-assignment-help
Facebook
Twitter