View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TonyJeffs TonyJeffs is offline
external usenet poster
 
Posts: 6
Default Copying the text from a text box to the clipboard

Why doesn't this work?
..................................
Private Sub CommandButton1_Click()
UserForm1.TextBox1 = "hi"
UserForm1.TextBox1.Copy
UserForm1.TextBox2.Paste
'why doesn't textbox2 contain "hi"?
End Sub
....................................

Thanks

Tony

ps it says in help:
..................................
Copy Method
Copies the contents of an object to the Clipboard.
<snip
On a TextBox or ComboBox, it copies the currently selected text.