Using data validation, you can't stop the data entry when the text
length limit is reached. Users can continue typing, and will only see an
error message when they press the Enter key.

If you want to include your email address in your message, you can munge
it. For example, you could use:
Then the address-harvesting robots will have a harder time using it, and
you might not be swamped with spam.

Curt wrote:
useing the following code what is missing to stop input when text data
validation is set. Drops down and continues input. Or can this be stopped?

.Add Type:=xlValidateTextLength, AlertStyle:=xlValidAlertStop, _
Operator:=xlLessEqual, Formula1:="234"
This is also in macro:
InCellDropdown = False
Thanks
When reply can you tell me if I need to show my e-mail address in post?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html