Question: 1 . Eva created a macro in Visual Basic named ClearData that clears the form for a new client. Add a button to run the

1. Eva created a macro in Visual Basic named ClearData that clears the form for a new client. Add a button to run the macro as follows:
a. In cell G17, insert a Button (Form Control) to the right of the Save Data button. Edit the button to use Clear to replace the placeholder text, and assign the ClearData macro to the new button.
b. Format the new button to change the height to 0.3" and the width to 1". Position the Clear button to align with the top of the Save Data button on its left.
2. Eva asks you to format the Save Data and Clear buttons so that they match. Change the format as follows:
a. Edit the Save Data button to display Save as the button text.
b. Change the font of both buttons to 11 point Lucida Grande (Body).
3. Test the form as follows to make sure it works as Eva intended:
a. Use the Save button to run the SaveData macro.
b. Unhide the Client Information worksheet to verify that it contains the data from the Survey worksheet.
c. Hide the Client Information worksheet.

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 Programming Questions!