Excel text box properties

Giganews Newsgroups
Subject: Excel text box properties
Posted by:  R Ormerod
Date: Fri, 3 Aug 2007

I have a text box inserted in my worksheet from the Control Toolbox toolbar.

Is there an option which allows me to specify that existing text in the box
is overwritten by new entries (I have the number of possible characters
restricted so this would be very useful). I can't find one in the Properties
window so maybe the only solution is VBA?


R Ormerod