Yes, but the formula bar is such an ugly place to view text, and it blocks
all of the cells under it.

That is a huge part of the reason I built the data entry form.

Thanks for your feedback.
--
Email address is not valid.
Please reply to newsgroup only.


"Kevin B" wrote:

There is a 32,767 character limit per cell, with only 1,024 displayed. You
can extend the 1,024 limit by forcing line breaks with <Alt + Enter if
typing, or vbNewLine constant by code.

BTW: The full 32,767 characters do display in the formula bar however.
--
Kevin Backmann


"Dale Fye" wrote:

I have an Excel workbook that I am using to capture data from remote sites.
They will be using a form to enter their data, but I just encountered a
problem while testing. I pasted about 3400 characters into a textbox and in
the AfterUpdate event attempted to use the following code to write that data
into a cell in my worksheet.

ActiveWorkbook.Sheets("Data").Cells(intRowPointer, 5) =
Me.txt_Soln_Description

But I got the following error: Run-time error '1004' Application-defined or
object-defined error.

When I selected "Debug", the line shown above was highlighted. When I
printed me.txt_Soln_Description in the debug window, it contained all of the
characters, and the row pointer was also valid.

When I pasted the characters directly into the worksheet cell, they were all
stored properly, and were visible in my form when I retrieved them. Is there
a limit to the number of characters I can put in a single cell? If so, what
is it?

--
Email address is not valid.
Please reply to newsgroup only.