NP_EX16_7a_DallasThompson_Report_3.xlsm

In the volunteer letterhead worksheet the merged

This preview shows page 1 - 2 out of 10 pages.

In the Volunteer Letterhead worksheet, the merged range A1:D1 should be formatted using the White, Background 1 font color and the Blue, Accent 5, Lighter 40% fill color. In the Volunteer Records worksheet, the contents of the range A1:D1 should be formatted using a 24 pt. font size. In the Volunteer Records worksheet, the merged range A1:D1 should be formatted using the White, Background 1 font color and the Blue, Accent 5, Lighter 40% fill color. Switch to the Volunteer Registration worksheet. Delete the defined name Volunteer_Data associated with the range C4:C8 on this worksheet. Dee created two macros to use on the Volunteer Registration worksheet. She wants you to review the macros and assign them to buttons, to make them easier to access. Assign the Clear_Data macro to the Clear Data macro button in the range B10:B11. In the Volunteer Registration worksheet, the Clear_Data macro should be assigned to the Clear Data macro button in the range B10:B11. Edit the Clear_Data macro (found in Module 1). In the Clear_Data macro VBA code, change the range used in the code to the range C4:C8. The edited code should read: Range("C4:C8").Select (see Figure 3 for details). Run the Clear_Data macro to confirm that the macro erases the values in the range C4:C8. (Hint: You must complete Step 17 correctly to receive credit.) Error found in file (In the Volunteer Registration worksheet, the Clear_Data macro should be modified and run to clear the original data in the range C4:C8. (Hint: You must complete Step 17 correctly to receive credit.)) Create a form control macro button in the range C10:C11, next to the Clear Data button and then complete the following actions: a. Assign the macro Record_Volunteer to the button. b. Change the button label using Record Volunteer as the new name. The Volunteer Registration worksheet should contain a form control macro button in the range C10:C11. In cell C6, create a data validation rule that will only accept date values corresponding to the dates of the Reclaim the River event as described below: a. The dates should be between 5/18/2018 and 5/20/2018. b. The input message should have the title Volunteer Date and should use the text Enter volunteer date. (including the period) as the Input message. c. The error alert should have the Stop style with Invalid volunteer date. (including the period) as the title. In the Volunteer Registration worksheet, cell C6 should contain a data validation rule that limits values to dates between 5/18/2018 and 5/20/2018. In the Volunteer Registration worksheet, cell C6 should have a data validation rule that limits values to dates between 5/18/2018 and 5/20/2018. In the Volunteer Registration worksheet, cell C6 should have a data validation rule that limits values to dates between 5/18/2018 and 5/20/2018. In cell C7, create a data validation rule that will only accept values from a list corresponding to the different assignment at the Reclaim by the River event as described below: a. The validation rule should ignore blanks and appear as an in-cell dropdown.
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Spring '16
  • Rausch
  • Visual Basic for Applications, Charles River, River Cleanup

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern