TextBox to Cell Freeze

[pigeonmilk]

Hi.

I have a textbox created in a userform in excel vbe, and is linked to a cell. But when I enter more than > ~920 characters it craps on me saying this

Run-time error '1004':
Application-defined or object-defined error

And points to this code

'Populate cells M1 to M28 with Textbox8 to Textbox35 information respectively
qq = 0
For zz = 8 To 35
qq = qq + 1
If qq <> 23 Then
this.Worksheets("FindingsData").Range("M" & qq) = UserForm1.Controls("TextBox" & zz) '*THIS*
If UserForm1.Controls("TextBox" & zz) = 0 Then
UserForm1.Controls("TextBox" & zz) = ""
End If
End If
Next

[RonMcK]

Which version? Help for Excel XP (2002) speaks of a display limit of 1,024 char and a max stored of 32,767 char.

[david000]

Your not placing a "Value" in the range.
like:

SomeRange = Userform1.Textbox1.Value

Posting a copy of your workbook would generate more critical feedback though.