Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |