SetFocus to select text (VBA Excel 2003)

Topic

New Reply

I’m trying to resolve the difference between the operation of the SetFocus method in Access and in Excel. In Access, issuing a SetFocus method on a form textbox will position the cursor at the beginning of any text already in that box and select (or highlight) that text. This way the next and subsequent keys pressed will automatically replace those that were selected. In Excel VBA this does not seem to happen. Instead, SetFocus on a textbox control will simply position the cursor at the end of any text already in that box selecting nothing. Highlighting to replace any text has to be down manually.

Is there any way in Excel VBA code to select (or highlight) any text already in a text box when bringing it into focus?

As always, thank you for your time,

John Littell

Reply | Quote

Replies

The following code will set focus to TextBox1 and select the entire contents of the text box:

With Me.TextBox1
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With

Reply | Quote

Hans,
Two new methods I’ve never seen before. This is really neat.

As always, thank you for your knowledge and time,

John

Reply | Quote