Textbox Default Value Not displaying During Userform Initialization; Selection Highlighting

[Ark68]

With the code below, I am trying to highlight a default value of 000000 in a textbox (textbox1) in my userform. This will allow the user to overwrite the default entry without having to first select it.

        With TextBox1               'rental number
            'cb_mri.Visible = False
            .Locked = False
            .BackColor = RGB(255, 255, 255)
            .Value = format(0, "000000") 'new rental
            .SetFocus
            .SelStart = 0
            .SelLength = Len(.Text)
        End With

The default value of "000000" isn't showing in the textbox let along that value being highlighted.

Is anyone able to tell me where the problem exists?

 

[My Aswer Is This]

Why do you believe you need to select the Textbox ?

Why not use a script like this:

Private Sub CommandButton2_Click()
'Modified  5/3/2019  9:52:30 PM  EDT
TextBox1.Value = "Cake"
End Sub

 

[My Aswer Is This]

Or if you want more then like this:

Private Sub CommandButton2_Click()
'Modified  5/3/2019  9:58:30 PM  EDT
With TextBox1
.Value = "Cake"
.BackColor = RGB(0, 255, 255)
End With
End Sub

 

[Ark68]

Hi My Answer Is This, thank you for your suggestions.

They would work, but they aren't providing the full feature of what my code is meant to do.

The purpose of selecting it, is that it will allow the user to overwrite the exisitng default value in the box. In your examples, the user will have to manually select the default text, deloete it, or overwite it. My code, which has worked in other instances, takes away the step of the user having to highlight (select) the text first on their own, it's done automatically. They can just type.

This concept ... but mine isn't working.
https://www.mrexcel.com/forum/excel-questions/211449-auto-highlight-text-textbox-userform.html

 

[Fluff]

What colour are you trying to make the textbox?

 

[Ark68]

Hi Fluff,

I'm trying to use a white background, with black font. I get a cursor in the middle of the textbox, but not a highlighted default value.

 

[Fluff]

I get 000000 in the textbox & that text is selected.
Try adding a new textbox (without changing any of the properties) & point the code to that textbox.
Does it work?

 

[Ark68]

Hi FLuff, thanks for your continued support.
As suggested, I created a new textbox and popinted that code to Textbox2. I got the same results. Blinking cursor ( | ) only.

 

[Fluff]

Is that code in the initialise event?

 

[Ark68]

Is that code in the initialise event?

Yes, it is.