Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying the text from a text box to the clipboard
Copy copies the selected text - you don't have any text selected:
Private Sub CommandButton1_Click() With UserForm1 ..TextBox1 = "hi" ..TextBox1.SelStart = 0 ..TextBox1.SelLength = Len(TextBox1.Text) ..TextBox1.Copy ..TextBox2.Paste End With End Sub works. But this is easier: Private Sub CommandButton1_Click() With UserForm1 ..TextBox1 = "hi" ..TextBox2.Text = .Textbox1.Text End With End Sub -- Regards, Tom Ogilvy TonyJeffs wrote in message om... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying text within a text box and losing formatting | Excel Discussion (Misc queries) | |||
Pasting delimited text from clipboard directly into Excel Spreadsh | New Users to Excel | |||
Truncated text when copying text from one excel doc to another | Excel Discussion (Misc queries) | |||
Pasting from clipboard-how to control text-to-columns delimiting | Excel Discussion (Misc queries) | |||
Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) |