Gtrain
06-28-2008, 05:51 PM
Guys,
just wondering if someone can shed some light on adding a wildcard to my case statement
Select Case comment
Case "NO TRAIN"
status1(UBound(Comments)) = 8
Case "NO TRAIN IN"
status1(UBound(Comments)) = 8
Case "NO TRAIN TO LOAD"
status1(UBound(Comments)) = 8
Case "WAIT FOR TRAIN"
status1(UBound(Comments)) = 8
Case "FINISHED TRAIN"
status1(UBound(Comments)) = 8
Case "TRAIN FINISHED"
status1(UBound(Comments)) = 8
Case "TRAIN BROKE DOWN"
status1(UBound(Comments)) = 8
End Select
I would like to case anything with train, but not training if possible
something like Case "*"&"TRAIN"&"*"
status1(UBound(Comments)) = 8
just drawing a blank. hopefully this is enough info!
just wondering if someone can shed some light on adding a wildcard to my case statement
Select Case comment
Case "NO TRAIN"
status1(UBound(Comments)) = 8
Case "NO TRAIN IN"
status1(UBound(Comments)) = 8
Case "NO TRAIN TO LOAD"
status1(UBound(Comments)) = 8
Case "WAIT FOR TRAIN"
status1(UBound(Comments)) = 8
Case "FINISHED TRAIN"
status1(UBound(Comments)) = 8
Case "TRAIN FINISHED"
status1(UBound(Comments)) = 8
Case "TRAIN BROKE DOWN"
status1(UBound(Comments)) = 8
End Select
I would like to case anything with train, but not training if possible
something like Case "*"&"TRAIN"&"*"
status1(UBound(Comments)) = 8
just drawing a blank. hopefully this is enough info!