Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF cell contains certain text return value | Excel Worksheet Functions | |||
Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
lookup a text cell and return text | Excel Discussion (Misc queries) | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
return textfrom cell into textbutton/commandbutton | Excel Programming |