Tab to textbox position

[ipbr21054]

Hi
Is it possible to tab to a position on a user form textbox ?

Example
Currently in TextBox1 then I use the tab button.
Now I’m in Textbox2

In textbox 2 will be a value of which I would like to be in position 2, make sense ?

Textbox2 value say ABCD
When I tab from textbox 1 I need to be between A & B

Thanks

 

[ipbr21054]

I’ve found this but where I found it didn’t say where it had to go

Me.TextBox2.Value = "()"
Me.TextBox2.SelStart = 1

 

[NoSparks]

try

Private Sub TextBox2_Enter()
    With Me.TextBox2
        .EnterFieldBehavior = 1
        .Value = "ABCD"
        .SelStart = 1
    End With
End Sub

 

[ipbr21054]

Thanks now done

 

[ipbr21054]

@NoSparks

Just on a side note.
As opposed to using ABCD what if i wanted to use "" between the 2 that are already there ?
S0 """"

I did try it but after the value was entered then i started to type the cursor jumped outside of the last "

 

[NoSparks]

Not sure what you have existing in the textbox
but think this is what you're asking about

Private Sub TextBox2_Enter()
    With Me.TextBox2
        .EnterFieldBehavior = 1
        .Value = """"""
        .SelStart = 1
    End With
End Sub

 

[ipbr21054]

Morning,
I tab to the Textbox in question but i am unable to type,i mean i type some text but nothing happens & i only see the quote marks

 

[NoSparks]

Works for me on my small test setup.
Won't try guessing at what your issue is.
If you made a file available and say what you're doing when this happens I'd have a look.

 

[ipbr21054]

As every its on a sheet with plenty of other stuff & my process for just sending 1 file here is a pain.

See if anything wrong here please,otherwise i will have to leave it

 

[NoSparks]

Use the _Enter event