The text can be up to 2000 characters.
The textbox is in a UserForm

Irais.

-----Original Message-----
Kali wrote:
The problem is: text box truncates text entered.

I am using
ActiveCell.Value = myTextBox.Text
ActiveCell.Value = Replace$(ActiveCell.Text,
vbCr, "")


How long is the text?
What kind of textbox are you using (UserForm?, Drawing
toolbar? ...)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

.