Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search/Match/Find ANY part of string to ANY part of Cell Value TWhizTom Excel Worksheet Functions 0 July 21st 08 08:16 PM
Two part question about dates and highlighting Steved Excel Worksheet Functions 3 December 12th 06 02:23 AM
part of string [email protected][_2_] Excel Programming 3 November 17th 05 12:22 PM
Use part of string Tempy Excel Programming 5 September 20th 05 11:44 AM
extracting part of string value Dr. Schwartz[_3_] Excel Programming 3 April 23rd 04 01:23 PM


All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"