pigeonmilk
07-29-2008, 01:57 PM
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
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