Excel/VBA: Copying text from UserForm Textbox to a Worksheet Textbox

[Neil Ives]

Sponsored Links

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

[Anirvinya]

There is a control called Microsoft Spreadsheet (right click on the toolbox , additional controls ) place this control on the userform and a label, if Excel file, do:
Label1.Visible = False
Spreadsheet1.Visible = True
and paste the beach in the Spreadsheet Control

If Word file, do :
Label1.Visible = True
Spreadsheet1.Visible = False
and paste the paragraph in the label.

[Neil Ives]

Thank you for your reply Anirvinya.

During the day I have discovered what the problem was and I've coded a solution.
Here's the page that gave me the information I needed.

http://support.microsoft.com/kb/105416

--
Neil Ives