Restrict no of chars in text box

  • Thread starter Thread starter Anita
  • Start date Start date
A

Anita

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
 
Right-click your text box, select properties, then change Max Length to your
desired length.
 
Right-click your text box, select properties, then change Max Length to your
desired length.
 
I don't get properties when i right click the text box - it wasn't created
using the forms text box (see below)... thanks
 
I don't get properties when i right click the text box - it wasn't created
using the forms text box (see below)... thanks
 
My bad, not good at the readin part. So, there's two options. you can
either change it to a control toolbox text box or you will need to do
programming and assign the macro to it. If option B, you'll probably want to
check the programming section of this discussion group.
 
My bad, not good at the readin part. So, there's two options. you can
either change it to a control toolbox text box or you will need to do
programming and assign the macro to it. If option B, you'll probably want to
check the programming section of this discussion group.
 
Can you replace it with a textbox from the control toolbox toolbar?

Those have many more features that you can customize.
 
Can you replace it with a textbox from the control toolbox toolbar?

Those have many more features that you can customize.
 
Back
Top