Way to go k!
-----Original Message-----

What is happening is that when you set the text box value
(I assume in
UserForm_Activate or UserForm_Initialize), it is acting
as if the value
was typed in (since it kind of was). To have it
highlighted, you must
highlight it:

Private Sub UserForm_Initialize()
TextBox1.Value = 12
TextBox1.SelStart = 0
TextBox1.SelLength = Len(TextBox1.Text)
End Sub

K


--
kkknie
----------------------------------------------------------
--------------
kkknie's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=7543
View this thread:
http://www.excelforum.com/showthread...hreadid=267397

.