View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anita Anita is offline
external usenet poster
 
Posts: 71
Default Restrict no of chars in text box

I've created a text box in Excel 2003 using the text box tool on the drawing
toolbar (didn't want to use other one as it prompts to enable/disable macros
which will confuse my users!)

How can I make it so that when users type into the text box they cannot go
beyond the boundary at the bottom - I have stretched it to the size I want
but don't want anyone typing further down as the text doesn't print out. Any
help/ideas gratefully received.

Thanks Anita