Value from Cell Onto Command Button

[Hjemmet]

Is it Possibel to get Value from Cell onto Commanbutton
So the Text on Commandbutton change if the text Change in a Specific Cell example If value in "D1" is " Player 1" then The Text on Command Button Also is "Player 1"

what i self have done so far was Searching around Google and Didn realy find what i was looking for

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Change the cell reference (in red) to suit your needs. Please note the button name (in blue). Close the code window to return to your sheet. Enter a value in D1 and press the ENTER key.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) <> "D1" Then Exit Sub
    ActiveSheet.CommandButton1.Caption = Target
End Sub

 

[Hjemmet]

Nohing Happen perhaps it because i AINT have any Userform but Only have Commandbutton insert on sheet's and It's Not Only Value But Text

 

[mumps]

What is the CommandButton name?

 

[Hjemmet]

What is the CommandButton name?

Commandbutton 1 in English on my Picture it is Danish "knap 1" it wont have any effect i change that when ive get the Solution

 

[Hjemmet]

 

[mumps]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) <> "D1" Then Exit Sub
    ActiveSheet.Knap 1.Caption = Target
End Sub

 

[Hjemmet]

Aint work is it Possibel for you to Make a Small File and Upload it

 

[mumps]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

 

[Hjemmet]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Testing Commando button.xlsx

Shared with Dropbox

www.dropbox.com