Preventing data entry once 1024 character limit is reached 1

[EliseFreedman]

Hi there

I have developed an excel spreadsheet which users will complete and send to your department to report when an incident has occurred onsite.

I have come across the 1024 character limit for displaying cell contents in excel. In a lot of cases, users are putting more than 1024 characters in the cell and my colleagues who have to deal with the received forms are complaining as they cant see the detail in the form.

To accomodate this I have added a section to my sheet for additional information. I have added data validation to the first cell to display an error message when the cell exceeds 1024 characters. The error message asks them to enter the remaining info into the additional information field. My problem is that the error message is not displayed until the user hits return to move to the next cell by which time he/she may have typed in a lot more than 1024 characters.

Is there any way in which a warning can be displayed as soon as the 1024 character limit has been hit?

 

[SkipVought]

Hi Else,

Use an embedded control toolbox textbox. You have the events to keep track of every keystroke.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Also take a look at Data Validation -- TEXT LENGTH.

Although it allows the typing of excess characters, it prevents finishing entering the data, so the editing of the cell can still take place.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[EliseFreedman]

Thanks so much Skip

By drawing my attention to the embedded control toolbox textbox, I accomplished in 10 minutes what I had been trying to do all day.

Elise

 

[SkipVought]

Wonderful!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}