R$$view and edit a spin button form control.

a$.$ Right$-$click the spin button control on the Daily sheet.

b$.$ Review the settings on the Control tab; note that the linked cell to the left of the control displays the

results.

c$.$ Click the Protection tah and deselect the Locked box. Click OK$.$

d$.$ Right$-$click the spin button control and select Edit Alt Text. Add the following alt text: This is a spinner

control to count clients..

e$.$ Click OK$.$

Copy and edit form controls.

a$.$ Confirm that the control is selected.

b$.$ Copy it to the Clipboard and paste it$.$

c$.$ Drag the copied control to cell C$7.$

d$.$ Paste again and drag the second copy to cell C$9.$

e$.$ Paste three times and position the controls as shown in Figure $7-86.$

f$.$ Select all six controls and align them on the right.

g$.$ Right$-$click the control in cell $C7$ and change the Cell link

to cell $$B$$$7.$

h$.$ Edit the linked cell for each of the controls.

i$.$

Delete any values that display in column B$.$

Insert a list box form control.

a$.$ Display the Developer tab on the Ribbon if it is not shown.