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!!!!
Bookmarks