textbox the cursor jumps to the end of the sentence

[Sahak]

Hi All,

The TextBox on User form gets a value from worksheet cell. When I want to edit a text, the cursor jumps to the end of the sentence.
any idea ?
(Excel 2007)

Thank you in advance.

 

[Kenneth Hobson]

SOP? I guess that is the first control to get focus?

To select at beginning:

Private Sub UserForm_Initialize()
  [A1] = "Ken"
  TextBox1.Value = [A1]
  TextBox1.SelStart = 0
End Sub

 

[Sahak]

Thank you Kenneth for reply.

I have no problem where to put the cursor, the problem is that when I want to edit any text in sentence, after typing one letter, or trying to add a word in sentence the cursor jumps to the end of the sentence.

 

[Kenneth Hobson]

The you have something going with code I guess...