Userform TextBox Value question

[Nalani]

On my UserForm I have a TextBox with the Value set to DRRC. (through Properties)

Tab Order is set, so when i get to that TB, DRRC is highlighled. I need the users to type in 6 numerical didgits after the DRRC.

Is there a way that when I Tab to that TB the cursor is positioned to the right of the DRRC instead of highlighting?

Yes I know that I could add another TB to separate the DRRC and the 6 digits then combine them through code. I really don't want to go that route if possible.

 

[Hermanito]

There might be a better way, but this does the trick:

Private Sub txbYourTextBox_Enter()
    SendKeys "{END}"
End Sub

Add this code to your userform codepane and replace the 'txbYourTextBox' with the real name of your textbox.

 

[Nalani]

Thank you Hermanito

That did the trick.