Unless you are referring to a Form Control, a control button has a property
called Caption, that is the name that appears on the button, not its's name
which is used by Excel and VBA code to identifiy it.
SO to change the caption, use
CommandButton1.Caption = "My Button"
To link this to a cell, you could use
CommandButton1.Caption = Range("A1")
To run the above manually store it in the code sheet for the worksheet where
the control is placed.
If you want it to automatically change it when the cell is changed, use the
change event, something like
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
CommandButton1.Caption = Range("A1").Value
End If
End Sub
--
Regards,
Nigel
"Tanya" wrote in message
...
Hi
Is it possible to have the description/label of a command button updated
by
the title in a sheet cell?
cheers
Tanya