Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting part of string?
Hi all, I have a comma deliniated textbox value error checker i.e. my procedure checks that all comma delinated values in a userform textbox control are valid. If not, a message box comes up informing the user of the invalid entry and the procedure is exited. I would like to have the invalid text within the textbox highlighted. Is this possible? If so, how would it be done? -- Ouka ------------------------------------------------------------------------ Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988 View this thread: http://www.excelforum.com/showthread...hreadid=501924 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlighting part of string?
With TextBox1
.SelStart = 5 .SelLength = 3 .SetFocus End With -- HTH RP "Ouka" wrote in message ... Hi all, I have a comma deliniated textbox value error checker i.e. my procedure checks that all comma delinated values in a userform textbox control are valid. If not, a message box comes up informing the user of the invalid entry and the procedure is exited. I would like to have the invalid text within the textbox highlighted. Is this possible? If so, how would it be done? -- Ouka ------------------------------------------------------------------------ Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988 View this thread: http://www.excelforum.com/showthread...hreadid=501924 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Two part question about dates and highlighting | Excel Worksheet Functions | |||
part of string | Excel Programming | |||
Use part of string | Excel Programming | |||
extracting part of string value | Excel Programming |