Select (highlight) Text in txtBox at Initialization

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

When tabing through the text boxes on my form all data within a text box is
selcted because the EnterFieldBehavior is set to select all. On form
initilization the first text box in the tab order has the cursor at the end
of the field. I want to have all text in this box selected at form
initalization.

You advise is appreciated to fill in the line of code below, txtBoxName,


Private Sub UserForm_Activate()
txtBoxName (select all the text in the box)
End Sub
 
Maybe

Private Sub UserForm_Activate()
With txtBoxName

.SelLength = Len(.Text)
.SelStart = 0
.SetFocus
End With
End Sub
 
Hi,

Try this

Private Sub UserForm_Initialize()
With Me.TextBox1
.Value = "test"
.SelStart = 0
.SelLength = Len(.Value)
End With
End Sub

Mike
 
Thanks Mike, Worked as needed.

Mike H said:
Hi,

Try this

Private Sub UserForm_Initialize()
With Me.TextBox1
.Value = "test"
.SelStart = 0
.SelLength = Len(.Value)
End With
End Sub

Mike
Click to expand...
 
Back
Top