comparing cell values to wildcards in a string?

robfritts · Apr 30th, 2002, 01:27 AM

I'm looking for a VBA argument to help me define criteria. I tried the conditional formatting, but I can't figure out how to type this formula. I want to ClearContents or DeleteRow for any cell value that is not in for format ##XXXXXX, where # is any numeric and X is any alpha character. I also want to do conditional formatting and highlight a cell if the criteria is "xxxxxxCEx3T" where
x is any alpha character. Am I just not finding the right wildcards to do this or using the wrong format/argument?

In case you couldn't tell, I'm new.

Tom Schreiner · Apr 30th, 2002, 01:39 AM

Use the Like Operator





MatchPattern = YourValue Like "##??????"

'if MatchPatter = False then delete your row

MatchPattern = YourValue Like "??????CE?3T"

'if MatchPatter = True then do your formatting

Tom

Apr 30th, 2002, 01:39 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Use the Like Operator MatchPattern = YourValue Like "##??????" 'if MatchPatter = False then delete your row MatchPattern = YourValue Like "??????CE?3T" 'if MatchPatter = True then do your formatting Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 01:27 AM	#1
robfritts New Member Join Date: Apr 2002 Location: KC, MO Posts: 18	I'm looking for a VBA argument to help me define criteria. I tried the conditional formatting, but I can't figure out how to type this formula. I want to ClearContents or DeleteRow for any cell value that is not in for format ##XXXXXX, where # is any numeric and X is any alpha character. I also want to do conditional formatting and highlight a cell if the criteria is "xxxxxxCEx3T" where x is any alpha character. Am I just not finding the right wildcards to do this or using the wrong format/argument? In case you couldn't tell, I'm new.