Forms Toolbar

//Thomas
"papou" skrev i meddelandet
...
Where did you get the "textbutton" from:
Forms tool bar
Controls Tool Box
?
Cordially
Pascal

"Jonsson" a écrit dans le message de
...
Hi Pascal

Thanks for your answer.

I'm sure the code is okay, but is it something I have to do to get the
code
working in my application.
It seems to be some problem, because the macro wont work for me.
My button is'nt a commandButton, it's a textbutton (hope you know what I
mean). Could that be the problem?

"papou" skrev i meddelandet
...
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