VBA CODE ONLY: The worksheet for Problem 2 contains data on several sales representatives for a publishing company. The data on each Sales Rep include last name, first name, gender, region of country, age, years of experience, and performance rating. When the user clicks the button Edit Sales Rep, the applications displays a form that asks the user for the last name and first name of a Sales Rep (see Figure 4 below). After the user enters the names, the program searches for a Sales Rep with this name. If none is found, a message to this effect is displayed and the program ends. If the Sales Rep is found, a second form is displayed with the information for the Sales Rep (Figure 5). The user can then change any of these values and click OK. The changes are then reflected in the data range.

The data sheet is

VBA ONLY

Find Sales Rep Enter the last and first name of the Sales Rep you would lke to edit. (If there is no such Sales Rep, no editing will occur.) OK Cancel First name: Last name: Figure 4 Problem 2 Find Sales Rep Form Edit the Sales Rep Information Now enter the new data for this rep. Leave the field as is if the information has not changed. OK Cancel Last name: Green Frst name: Gordon 36 Years experience: 8 Region Rating C East C Mediocre Male C Female Midwest Northeast South Good C West Fioure 5 Problem 2 Edit the Sales Ren Information Form Find Sales Rep Enter the last and first name of the Sales Rep you would lke to edit. (If there is no such Sales Rep, no editing will occur.) OK Cancel First name: Last name: Figure 4 Problem 2 Find Sales Rep Form Edit the Sales Rep Information Now enter the new data for this rep. Leave the field as is if the information has not changed. OK Cancel Last name: Green Frst name: Gordon 36 Years experience: 8 Region Rating C East C Mediocre Male C Female Midwest Northeast South Good C West Fioure 5 Problem 2 Edit the Sales Ren Information Form