General Instructions:

You have volunteered to help with an event designed to bring pet owners together for them to learn more about the types of places in the city where you live where pets of all kinds can socialize and have fun in addition to the other types of services available to pet owners. You have decided to create an input form in an Excel worksheet to accumulate the information. On that form, a button will be enabled to execute a VBA procedure to add the information to another workbook, which will be the main repository of data. After the information is added, the form should be cleared by the code to prepare it for the entry of the next owner. Also, another button should be available to delete the last entry in case it needs to be removed and redone.

Specific Instructions:

Follow the steps below to complete this question.

A) Create a new procedure named AddParticipant. When creating code for this procedure, the focus should not visually shift away from the Entry Form sheet at any time.

B) Create code to insert a new entry into row 3 of the Participant List sheet while pushing the current information down 1 row.

C) Create code to fill in the fields in this new row with the appropriate data from the form.

D)Create code to select cell C5 in the Entry Form sheet so that the form will be ready for the next participant to be entered.

E)Create a command button in the Entry Form sheet that covers the range A27:D29. Place the text Add Participant and Pets within the button and link the button to the AddParticipant procedure.

F) Create a new procedure named RemoveLastEntry. When creating code for this procedure, the focus should not visually shift away from the Entry Form sheet at any time.

G) Create code in this procedure to remove the last person/pet in the Participant List and shift the data up 1 row.

H) Create code to select cell C5 in the Entry Form sheet so that the form will be ready for the next participant to be entered.

I) Create a command button in the Entry Form sheet that covers the range E27:H2 Place the text Remove Last Entry within the button and link the button to the

RemoveLastEntry procedure.

All information is HERE and this assignment is focusing on the VBA system within excel. Complete parts A-I of question. Will do thumbs up when answered correcly and fully

D31 fr G H B E F 1 Pet Play and Service Event 2 3 Thursday, April 15, 2021 4 5 Owner Name: 6 7 8 Owner Address: 9 10 Street or PO Box 11 12 City 13 14 State Abbr. 15 16 17 18 Pet Information: 19 Name 20 Zip Type (e.g., Dog, Cat) Pet 1 Pet 2 Pet 3 21 22 23 24 25 26 27 28 29 30 31 32 33 Entry Form Participant List A B C D L 1 E F G H I J K Pet Play and Service Event Master List OZip Pet1Name Pet1Type Pet2Name Pet2Type Pet3Name Pet3Type 2 OName OStreet O City OState 3 4 . . nonoom Food a e non 39 Entry Form Participant List