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...Code: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. =)Code:redwhitenbluecheck = activecell like "red" OR "white" OR "blue"
There are currently 1 users browsing this thread. (0 members and 1 guests)