Question: Requirements: For following tasks, please create a module in VA and build macros to finish these tasks. You must code it manually ( i .

Requirements: For following tasks, please create a module in VA and build macros to finish these tasks. You must code it manually (i.e. recording is not allowed in this part). Please insert a comment to include your name(s) at the beginning of the module. Boldface the font of the label in cell A1, change its font size to 14, and font type to "Georgia". Boldface and italicize the headings in row 3, change their horizontal alignment to center, and vertical alignment to center. Change the color of the font for the Employee ID numbers in column A to red (any color you like), and alignment to center. Change the background (the Interior property) of the range with scores to light gray (or any similar color). Enter the label "Averages" in cell A22 and boldface it; enter the label "Sum" in cell A23 and boldface it. Enter a formula in cell B22 that averages the scores above it. Copy this formula to the range C22:F22. Change the horizontal alignment to right, and vertical alignment to center Enter a formula in cell B23 that sums the scores above it. Copy this formula to the range C23:F23. Change the horizontal alignment to right, and vertical alignment to center 1. In a separate module (insert/create another module), based on the value of the score, use IF construction and loop to create a sub procedure to change the font color of the score (one color for each range of the score). You may use any colors you like: score =9085 score <9075 score <8565 score <75 below 65, do not change the font color. Please be noted: when you save your work, make sure you save it as the xism format (i.e. macro-enabled workbook). This is very important, otherwise you may lose all the macros/codes.

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!