Return text in textButton from cell
Hi all,
I need to change the text in textButton by doing the following:
When I write for instance"2" in cell A2 I want the "2" value to be displayed
as text in the textButton
I got this code from "papou" just a while a go, but I need to modify it so
it works in a textbutton instead(the one you get from "Format" toolbar).
I have tried to record the event but I failed it.
A little twist: I have 30 buttons I want to be able to do this
on...............
Thanks in advance!
//Thomas
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
|