Restrict Data Entry

[Jonsey]

Is there any way to restrict the number of characters that can be entered
into a cell. I know with Data Validation, that if a character limit is
exceeded, one will get an error message.

What I would like to do is set up the cells so that once the character
limit is reached, the cell won't accept anymore characters and/or some sort
of audible warning sounds.

Any help will be appreciated.

 

[Dave Peterson]

I think that the only way you'll be able to do this is to create a userform with
a textbox where you could count the characters.