Question: Add a form control button in cell F 1 that will run the ClearContents macro. Change the text on the button to Clear Contents and
Add a form control button in cell F that will run the ClearContents macro. Change the text on the button to Clear Contents and then resize the button as necessary to read all the text.
Enter the following data in the report to test the macro:
In cell G using the list arrow, select Jamie
In cell G todays date
In cell G: PM
In cell B enter todays date
In cell C select Cards from the list arrow
In cell D type
Test the ClearContents macro by clicking or pressing the Clear Contents form control button.
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
