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
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 G 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 and the width to Position the Clear button to align with the top of the Save Data button on its left.
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 point Lucida Grande Body
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
