Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel text box properties
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? Thanks -- R Ormerod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel text box properties
You can have this code when the text box gets the focus:
Private Sub TextBox1_GotFocus() TextBox1.SelStart = 0 TextBox1.SelLength = Len(TextBox1.Value) End Sub (Replace TextBox1 by the name of your textbox, it appears four times) -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using properties in text formulas | Excel Discussion (Misc queries) | |||
Excel Properties | New Users to Excel | |||
How do I set Default import properties such as Text Qualifier? | Excel Discussion (Misc queries) | |||
Excel properties - 'archive'? | Excel Discussion (Misc queries) | |||
Converting custom cell properties to text | Excel Discussion (Misc queries) |