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