Hello Patrick,

There really isn't any good way to restrict the number of lines in
multi-line text box. The font size, font style, box size, and case al
effect the wrap around feature which can't be detected in an event lik
pressing the enter key. If there were a window handle to the text bo
this could accomplished using API calls from VBA.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=55918