ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Limit characters in a word/text box in excel (https://www.excelbanter.com/excel-programming/341402-limit-characters-word-text-box-excel.html)

Alex Martinez

Limit characters in a word/text box in excel
 

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.




Peter[_55_]

Limit characters in a word/text box in excel
 
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.






All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com