Error when string length > 1024 and starts with -

  • Thread starter Thread starter Dianne
  • Start date Start date
D

Dianne

Using XL97 SR2. This is more of a puzzle rather than a showstopper, but
I am curious.

In my application, there is a cell that stores a foreman's diary. This
is populated with a userform. Today I had one user getting an Error 7:
Out of Memory when he entered a lot of text. I finally figured out why
and when -- if the length of the string was > 1024 *AND* it began with a
hyphen (he uses the hyphen to do bullet points). It was fine if the
length was < 1024 and began with a hyphen, or if it was > 1024 and
didn't begin with a hyphen.

As far as I can tell(!), my code isn't bizarre in any way:

Private Sub cmdOK_Click()

Dim strDiary As String

strDiary = Application.WorksheetFunction. _
Substitute(txtDiary.Text, Chr(13), "")
ActiveWorkbook.Worksheets("Diary"). _
Cells(DIARY_ROW, DIARY_COL).Value2 = strDiary
frmDiary.Hide

End Sub

For now, I've told him not to use the hyphen at the beginning of his
diary -- a space or asterisk or anything else -- so we're working around
it. I will eventually modify the code to detect an initial hyphen and
remove it.

Does anyone have any explanation for this? Or is it just a weird
anomaly?
 
A guess but what about Excel seeing the text beginning with a hyphen as a
formula ?

Also is there a limit of 1024 characters in a cell?

Cheers
N
 
Also is there a limit of 1024 characters in a cell?

No: 32,000

--
Michael Hopwood


Nigel said:
A guess but what about Excel seeing the text beginning with a hyphen as a
formula ?

Also is there a limit of 1024 characters in a cell?

Cheers
N







----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
Click to expand...
=---
 
Without the hyphen, more than 1024 characters do display in the cell (if
the cell is formatted as General -- if it's formatted as Text then I get
####s). Weird.
 
Back
Top