VBA Userform Textbox - cursor to end of line after "TAB" selection (deselect content)

[Llupo01]

Hello,

I would like to ask you for help... I cannot figure out, how to cancel selection of all text in textbox, after I activate this textbox by TAB key. This textbox has some pre-inserted value depending on previous combobox, anyway I would like to start typing after this pre-selected text when I activate this textbox - put cursor on 5th position and dont have text highlighted inside this textbox.

I tried Enter event, when tried

txt1.selstart = 5

,

txt1.setfocus

and combinations of selstart, selLenght etc...nothing wokred...it is always all highlighted, when I enter this textbox using tab order and key TAB.

Thank you in advance,

brgds,
Tomas

 

[dmt32]

Hi
Try following & see if helps you

Private Sub TextBox1_Change()
    Dim ComboText As String
    ComboText = Me.ComboBox1.Value
    With Me.TextBox1
        .EnterFieldBehavior = fmEnterFieldBehaviorRecallSelection
        If Len(.Text) < Len(ComboText) Then .Value = ComboText
    End With
End Sub

Change control names shown in BOLD as required

Dave