Question: Woon's plan is that when users click the Add Client button in cell C 1 , the Clients worksheet opens and Excel adds a new,
Woon's plan is that when users click the Add Client button in cell C the Clients worksheet opens and Excel adds a new, blank record to the Client table, where users can insert the new client information.
Record a macro to automate the Add Client button as follows:
a Enable all macros in the workbook if necessary and then display the Developer tab on the ribbon.
b Begin recording a macro stored in this workbook using AddClient as the name of the macro.
c Display the Clients worksheet, and then add a new blank record to the end of the Client table.
d Stop recording the macro.
e Assign the AddClient macro to the Add Client button on the Home Page worksheet and then run the AddClient macro to make sure it inserts a new record at the bottom of the Client table on the Clients 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
