Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi I am using Excel 2002 and I am wondering how can I limit only 100 characters in a text box or a Word object (called object10) in Excel? The text box or my word object is sized accordingly, but it is just for notes. Sometimes a user wants to write a letter, which I don't want. Any tips will be appreciated. Thank you. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
In the textbox properties select "maxlength", there you can put in the amount of caracters you need. Regard, Peter "Alex Martinez" schreef in bericht ... Hi I am using Excel 2002 and I am wondering how can I limit only 100 characters in a text box or a Word object (called object10) in Excel? The text box or my word object is sized accordingly, but it is just for notes. Sometimes a user wants to write a letter, which I don't want. Any tips will be appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Character Path Limit for Asian Characters | Excel Discussion (Misc queries) | |||
Limit to 5 characters... | Excel Worksheet Functions | |||
Counting characters in text cell to find 255 limit | Excel Discussion (Misc queries) | |||
Filling cells with Word text characters | Excel Discussion (Misc queries) | |||
Can excel limit the characters in a cell to 28 automatically? | Excel Worksheet Functions |