View original (French)

VBA EXCEL usage.like

Solved
Sansandrine Posted messages 94 Status Membre -  
Sansandrine Posted messages 94 Status Membre -
Hello,

I use the formula If range("b2") like "*rdc*" ... to apply formatting to a part when the word rdc appears in the phrase located in B2. But I would like to add a condition like: if there is "rdc" or "etage" or "grenier" and I can't find how to do the "OR" with the like function.
Can someone help me?

Thanks in advance

Configuration: Windows XP / Firefox 3.6.2

1 réponse

Réponse 1 / 1
chossette9 Posted messages 6855 Registration date   Status Contributeur Last intervention   1 313
 
Hello,

in VBA, the logical operator OR is "Or". In your formula, it would be: 
If Range("B2") like "*rdc*" Or Range("B2") like "*etage*" Or Range("B2") like "*grenier*" Then


Best regards.
--
That guy wasn’t very bright, because he was foolish.
3
Sansandrine Posted messages 94 Status Membre
 
Thank you very much!
I knew that OR was there, but I didn't know how to place it in the sentence...
0