Assignment #9   (20 points)

  1. Watch the video String Manipulation (Names) (CC).

  2. Create working command buttons that can extract the first and last names in a Microsoft Excel file using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. The interface can be downloaded from the Assignment #9 folder. Save your work as "assignment9A.xlsm". The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)". Upload this file to your YOUR-CLASS-WEBSITE. Help.

  3. Watch the video String Manipulation (Dates) (CC)

  4. Create a working command button that can extract the month, day, year, month abbreviation, and year abbreviation in a Microsoft Excel file using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. The interface can be downloaded from the Assignment #9 folder. Save your work as "assignment9B.xlsm". The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)". Upload this file to your YOUR-CLASS-WEBSITE. Help.



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
Effectively created command buttons that can extract the first and last names in a Microsoft Excel file using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image above. 10 0 5 10 __/10
Effectively created a working command button that can extract the month, day, year, month abbreviation, and year abbreviation in a Microsoft Excel file using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image above. 10 0 5 10 __/10
Total points __/20