Labelling The Button

This is fine but the name Button1 does not mean much so we will change it.

Normally clicking on a button causes it to execute the macro associated with it, therefore we must select the button without it executing.

Hold down the control key and click the button.

The Button handles should now appear.

You can now resize it or move it with the handles.

We wish to change its label from Button1 to something more meaningful.

Clicking the Button1 object a second time causes the text editing cursor to appear.

Type in Your Name and click elsewhere on the worksheet.

The Button Label is now changed.


Practice Exercise

You should attempt the VBA Macro - Exercises d, e and f from the Spreadsheet Exercises listed in the Topic Menu below.