I use 'like' statements in vba fairly regularly- example:
i was wondering if anyone knew a way to add more than one condition to a "like" statement- such as...VB:passcheck = activecell Like "*Pass*" 'and then.. If passcheck = True Then totalpasscount = totalpasscount + 1 End If
passcheck = activecell like "Pass","P","*ass"
which would sure help cause then i wouldnt have to code the same cellcheck 3 times. anyone know if its possible?
actually... the more i think about it, the more i doubt its an option.
i actually need it to set the cell check to true based on an OR statement: such as:
anyway, if you have any input, its appreciated. =)VB:redwhitenbluecheck = activecell Like "red" Or "white" Or "blue"
There are currently 1 users browsing this thread. (0 members and 1 guests)