Hi
In Cell A1 I typed in the formula Rept("a",32767) and got a string, but
when I typed in Rept("a",32768) I got an error. This seems to suggest
that you get about 32K characters. I don't know if you can do better
from VBA

N E Body wrote:
Hi

Is there a limit to the number of characters allowed in a cell (or is it
just a limit to the size of a formula)

I have a userform which has a textbox for collecting information. The user
types a message (some of which can be quite long.)
The code runs and does various things including transfering the text from
the textbox into a cell on the worksheet.

Will I have any limitations?

Kenny
Win 2000 and Excel97