Multiple Conditions - IF - with what else ???

[Dave Wheeler]

Use the IF and &IF frequently in my sheet formulae
Also notice it's quite a popular "board" formula subject
But haven't seen much on Coding advice for same
Have "Option Boxes" with range of file names that would be handy to have "linked" with the msgbox vbok - and narrow down selection options
Suggestions to do this
I want to "link" - if filename.value = true....and.... if ans = vbok then
oh....the msgbox comes from a simple commandbutton click
Is there something in the "case select" or anything "nice and easy" that I could use
I'm just learning.....
Thanks

 

[marka87uk]

I'm not quite sure what you're asking?! You can use the AND operator as you said in macro's, and in formulas you can nest IF statments.

IF strA="A" AND strB="B" THEN

IF(A1="A",IF(A2="B",True,False),False)