View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Textbox question

Jorge,

That should do just that, the
..SelLength = Len(.Text)
sets the whole text length


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jorge Rodrigues" wrote in message
...
Hi, Bob
As I understood, the focus now, with your exemple, goes to the beginning.
Ok, but what I really want is hilight all the word/number, from the
beggining to the end. Can you help me once more time?
Thanks and Regards.
Jorge
"Bob Phillips" escreveu na mensagem
...
Jorge,

Try something like

Private Sub TextBox1_Enter()
With TextBox1
.SelLength = Len(.Text)
.SelStart = 0
End With
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jorge Rodrigues" wrote in message
...
Hi, guys
I have a textbox and what I want is, when is set focused, hilight all

the
word/number, in order to override the old one by the new. As far as I
saw,
the cursor only goes next to the last digit, don't hilight all the
number/word.
TIA
Jorge