An If Question in VBA

[hatstand]

I've wrote this to check a cell for one of two words. It will look for one word, but how do I make it look for either word? Calc being a macro! Am I on the right track?

If Range("B1").Value = "First" Then Calc
If Range("B1").Value = "Second" Then Calc

 

[venkat1926]

in spreadsheet in C1 type
=if(or(B1="first",b1="second" ),"yes","no")

in vba
if range("B1")="first" or range("B1")="second" then
.................
....................

 

[njimack]

No need for the formula in C1. Simply use the following code:

If Range("B1").Value = "First" or Range("B1").Value = "Second" Then Calc

 

[hatstand]

Thanks

A big thank you to both of you who offered help. It works perfectly.