Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part text in a textbox
Hi I have been trying to select a part of a text entry into a textbox, I
tried to use selstart etc I can remove the text but not hightlight it can someone show me how this can be done. TIA Charles |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part text in a textbox
Hi Charles
With TextBox1 .Text = "Harald says cool, man" .SelStart = 12 .SelLength = 4 End With HTH. best wishes Harald "vqthomf" skrev i melding ... Hi I have been trying to select a part of a text entry into a textbox, I tried to use selstart etc I can remove the text but not hightlight it can someone show me how this can be done. TIA Charles |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part text in a textbox
I tried to doing it like this but I still can get it to select the text, if
the user enters let say more than 5 digits I want to highlight the extra digits to give the user a chance to view or delete it. Regards Charles "Harald Staff" wrote: Hi Charles With TextBox1 .Text = "Harald says cool, man" .SelStart = 12 .SelLength = 4 End With HTH. best wishes Harald "vqthomf" skrev i melding ... Hi I have been trying to select a part of a text entry into a textbox, I tried to use selstart etc I can remove the text but not hightlight it can someone show me how this can be done. TIA Charles |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part text in a textbox
Did my code not work ?
Exactly when and how do you want this to happen, are you calling the code from an event ? Which event ? Do you have some annoying messagebox prior to this action ? Don't. Seeing your code would help me help you. Best wishes Harald "vqthomf" skrev i melding ... I tried to doing it like this but I still can get it to select the text, if the user enters let say more than 5 digits I want to highlight the extra digits to give the user a chance to view or delete it. Regards |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part text in a textbox
Harald I do have a message explaining that the user has entered more or less
than 5 digits but I also wanted to highlight the part that is extra. Charles "Harald Staff" wrote: Did my code not work ? Exactly when and how do you want this to happen, are you calling the code from an event ? Which event ? Do you have some annoying messagebox prior to this action ? Don't. Seeing your code would help me help you. Best wishes Harald "vqthomf" skrev i melding ... I tried to doing it like this but I still can get it to select the text, if the user enters let say more than 5 digits I want to highlight the extra digits to give the user a chance to view or delete it. Regards |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part text in a textbox
Sure, go a head, highlight the extra parts. My code sample showed you how to
do it. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting right part of text string | Excel Worksheet Functions | |||
Selecting All Text in TextBox | Excel Programming | |||
Help: selecting part of an array | Excel Programming | |||
Selecting or Entering a Textbox | Excel Programming | |||
Selecting used part of a range | Excel Programming |