ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   textbox value (https://www.excelbanter.com/excel-programming/362574-textbox-value.html)

No Name

textbox value
 
I have a form that is like a calculator. As it is called, the form has a
text box with a value = 0. As the user types in his value, the "0" does not
disapear like a calculator would. Is there a way to set the textbox to
clear it's content as the user enters his value.

If the user type the value 20 I'd like "20" to show not "020"

thx

MD



bgeier[_17_]

textbox value
 

In the properties for the control, set
"EnterFieldBehavior" to "0 - fmEnterFieldBehaviorSelectAll".
This way when the user selects the textbox the entire field will be
selected and anything typed will be overwritten


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546040



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

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