I have several textboxes that the user tabs through. I would like th
contents of the textbox to be highlighted (selected) whenever the use
tabs into a new textbox. is this possible. the way it is set up no
when the user tabs into a new textbox he/she has to backspace over th
contents to input new information.

Thanks

--
Message posted from http://www.ExcelForum.com

Private Sub TextBox2_Enter()
With TextBox2
.SelStart = 0
.SelLength = Len(.Text)
.SetFocus
End With
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"bforster1 " wrote in message
...
I have several textboxes that the user tabs through. I would like the
contents of the textbox to be highlighted (selected) whenever the user
tabs into a new textbox. is this possible. the way it is set up now
when the user tabs into a new textbox he/she has to backspace over the
contents to input new information.

Thanks.


---
Message posted from http://www.ExcelForum.com/

For a userform, the default behavior of tabbing to a textbox is to highlight
the text already there. At least that has been my consistent experience.

--
Regards,
Tom Ogilvy

"bforster1 " wrote in message
...
I have several textboxes that the user tabs through. I would like the
contents of the textbox to be highlighted (selected) whenever the user
tabs into a new textbox. is this possible. the way it is set up now
when the user tabs into a new textbox he/she has to backspace over the
contents to input new information.

Thanks.


---
Message posted from http://www.ExcelForum.com/