Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict no of chars in text box
Right-click your text box, select properties, then change Max Length to your
desired length. "Anita" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict no of chars in text box
I don't get properties when i right click the text box - it wasn't created
using the forms text box (see below)... thanks "Sean Timmons" wrote: Right-click your text box, select properties, then change Max Length to your desired length. "Anita" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict no of chars in text box
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. "Anita" wrote: I don't get properties when i right click the text box - it wasn't created using the forms text box (see below)... thanks "Sean Timmons" wrote: Right-click your text box, select properties, then change Max Length to your desired length. "Anita" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict no of chars in text box
Can you replace it with a textbox from the control toolbox toolbar?
Those have many more features that you can customize. Anita wrote: I don't get properties when i right click the text box - it wasn't created using the forms text box (see below)... thanks "Sean Timmons" wrote: Right-click your text box, select properties, then change Max Length to your desired length. "Anita" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restrict cell entry until another cell has random text | Excel Discussion (Misc queries) | |||
import text file with tab chars in it | Excel Discussion (Misc queries) | |||
sum first 2 chars if 3rd is something... | Excel Discussion (Misc queries) | |||
determine if ea value in a col has more than 20 chars | Excel Discussion (Misc queries) | |||
Header/Footer max 255 chars | Excel Discussion (Misc queries) |