accidentally posted question in Worksheet Functions area.

Is there a way to user multi-line in a control textbox (in the worksheet,
not a form), but limit to a certain number of lines. Say if the entry should
only be allowed to be 5 lines...

There's a character limit, but not all characters are the same size, and not
all lines are necessarily fully used, etc. The user doesn't want the area to
resize, but doese want to limit so that text cannot be entered after the
visual limit is reached.

So I was thinking of using the keydown event in the textbox to control all
this.

got it.

LineCount property.

don't know why I didn't see it early.

see ya.

"mark" wrote: