Thread: StrComp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rick is offline
external usenet poster
 
Posts: 334
Default StrComp

How can I do a StrComp of multiple text strings?
Example: StrComp(Target.Offset(0, -5).Text, "AMX", vbTextCompare) = 0
or StrComp(Target.Offset(0, -5).Text, "AMX, BAVR, BAVS", vbTextCompare) = 0
or is it
StrComp( Target.Offset(0, -5).Text, "AMX",Target.Offset(0, -5).Text,
"BAVR",Target.Offset(0, -5).Text, "BAVS", vbTextCompare) = 0
or is it something else
AMX or BAVR or BAVS can be in a given cell and I do postings based upon the
cell value.