From Forms documentation:
By default, you can enter up to 2048 characters in a text box. If you set
the MultiLine property to true, you can enter up to 32 KB of text
From Excel Specs:
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.
Alternative: if you need to exceed these specs you may need to imbed another
"text" object; e.g. a Word document, in your sheet.

"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