Highlight text in textbox

  • Thread starter Thread starter Erwin Bormans
  • Start date Start date
E

Erwin Bormans

Hi all

I want to highlight all the text in a textbox when I click on it so the user
can start typing a new value straight away.

I tried playing with selstart and sellength but it doesn't work.

Anybody an idea.

Kind Regards
Erwin
 
Try something similar to the following in your click or doubel click event

Me.Text1.SetFocus
Me.Text1.SelStart = 0
Me.Text1.SelLength = Len(Me.Text6.Value)

where Text1 is the name of your textbox.
 
Sorry, I made a small typo. Here it is corrected.

Me.Text1.SetFocus
Me.Text1.SelStart = 0
Me.Text1.SelLength = Len(Me.Text1.Value)
--
Hope this helps,

Daniel Pineault
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight Text In A Textbox 3
move cursor to end of box to get rid of highlight 1
Highlight Value of Text Box 1
Click event for UserForm Multipage 1
Dynamically update userform label based on textbox 5
Problem SelStart and SelLength 1
Excel Adding Text to a Textbox in Excell 1
Spell check - round two 2

Back
Top