Multiple Conditions - IF - with what else ???

Dave Wheeler

New Member
Joined
Jul 24, 2007
Messages
30
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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

marka87uk

Board Regular
Joined
Mar 24, 2007
Messages
247
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)
 

Forum statistics

Threads
1,181,658
Messages
5,931,271
Members
436,785
Latest member
KingGideon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top