VBA Problem : IF OR Statement not displaying correct

[zachcone]

This is probably a stupid question but below is a VBA string the goal is to hide sheets and data if a certain statement is true or false. The issue is there are three "options" on the sheet (Yes Conventional, No, and Yes Engineered). If either yes statement is true it should display certain data that it is only hiding if the third option is true. I know you may need more context so please just let me know! Any help or theory is greatly appreciated!

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Hi and welcome.

First off, to appease the forum gods (the moderators) you'll need to go back and edit your original post to include code tags. Edit the post, highlight the code section, click the # icon above your message then save.

Might be worth adding a sample workbook too (desensitized if necessary) as it's often easier to help when we can see the issue in context.

Sounds like it will be a quick and easy fix though.

BSB

[zachcone]

Added Thank you!

[BadlySpelledBuoy]

Could you explain what you need it to do? At the moment I have no idea what's not working with what you have.

BSB

[zachcone]

If basement / crawl is yes conventional it needs to show first floor joists, basement walls, and basement stairs. If it is yes engineered it needs to show only basement walls and basement stairs but not first floor joists.

Some how the second floor needs the same thing but is working perfectly so that doesnt have to be fixed!

sorry for the confusion! Thank you!!