Thread: First textbox in form not accepting input properly
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kkknie[_218_] kkknie[_218_] is offline
external usenet poster
  
Posts: 1
Default First textbox in form not accepting input properly

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

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



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26739

Reply With QuoteReply With Quote