LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restrict cell entry until another cell has random text Forum freak \(at work\) Excel Discussion (Misc queries) 3 October 24th 08 04:19 PM
import text file with tab chars in it nrao Excel Discussion (Misc queries) 1 September 25th 08 06:46 PM
sum first 2 chars if 3rd is something... [email protected] Excel Discussion (Misc queries) 13 September 29th 06 02:30 PM
determine if ea value in a col has more than 20 chars pmms Excel Discussion (Misc queries) 2 March 16th 06 03:11 PM
Header/Footer max 255 chars Roland Excel Discussion (Misc queries) 1 May 7th 05 12:51 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"