If the button is a Control Toolbox button, you can use the following Change
event macro to change the caption of the button to whatever is currently in
C4.
This is a sheet macro and must be located in the module for that sheet.
Right-click on the sheet tab and select View Code, then paste this macro
into the displayed module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If Target.Address(0, 0) = "C4" Then _
CommandButton1.Caption = Target.Value
End Sub
"Adam" wrote in message
...
Is it possible to assign name of a button as a formula i.e. e.g. the
content
of cell C4?