Hi,
VBA in Excel 2003:
Using code I'm trying to copy text entered by the User in a UserForm
textbox to a worksheet textbox that has just been created. My code
seems unable to paste more than a certain number of characters, ie. if
there are more than about a hundred characters, (I have not yet
counted) nothing gets entered into the Worksheet textbox. However, if
I manually copy and paste, (Ctrl C, Ctrl V) from one to the other all
of the text copies.
Here are my two lines that create a textbox on the worksheet then
(should) copy the text from my UserForm Textbox.
ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 124#,
134#, 100, 100).Select
Selection.Characters.Text = UserForm.TextBox1.Text
Do you have any ideas what's wrong here?
Many thanks.
--
Neil Ives
Bookmarks