Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox question
Thanks Bob
Jorge "Bob Phillips" escreveu na mensagem ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox Question | Excel Discussion (Misc queries) | |||
Textbox question | Excel Discussion (Misc queries) | |||
Textbox question? | Excel Discussion (Misc queries) | |||
textbox question | Excel Programming | |||
Textbox question 2 | Excel Programming |