Private Sub CommandButton1_Click()
myValue = TextBox1.Value
MsgBox myValue
End Sub
rogersj said:I dont need it to copy anymore, I just need the button to select/highlight the text within the text box
Thanks again
Private Sub CommandButton1_Click()
TextBox1.SelStart = 0 'Indicates the starting point of selected text
TextBox1.SelLength = 500 'number of characters selected in a text box
TextBox1.SetFocus 'Moves the focus to this instance of an object.
TextBox1.Copy 'Copies the contents of an object to the Clipboard.
End Sub