Hey all, I am trying to take the value of a certain cell and put that text in my command button.. here is the help I have already recieved....


-Add an OLE command button:
(view->toolbars->control toolbox)

-right click the button ->properties, give the button the name: cmdButton
-ALT + F11 brings you to the VB editor,
-select the sheet where the button resides
-select the Worksheet Change event
-enter the following code:

Private Sub Worksheet_Change(ByVal Target As Range)

cmdButton.Caption = Target.Value

End Sub


I can't seem to figure out what to change in that to make my Command Button to link to Cell C45 on Worksheet("Cover"). I have tried several things and my text just keeps turning red and an error occurs. Please Help!!!!