Hello
Place this in the sheet's code and amend accordingly:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$15" And Target.Value < "" Then
Me.CommandButton1.Caption = Target.Value
End If
End Sub

HTH
Cordially
Pascal

"Jonsson" a écrit dans le message de
...
Hi all,

Is it possible to return a textvalue from a cell into a
textbutton/commandbutton so that the text in the button changes depending
of
what you write in the cell?
If so, how to do it?

Any help is apprecciated!!

//Thomas