View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default limiting rows in a text box?

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.