• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Revealing Control Buttons when a pair of conditions is met

Matt Burns

New Member
Hello Chandoo Community,

I've found a few threads related to hiding/revealing control buttons based on a cell's value but have thus far been unable to translate that information into what I need my Excel sheet to do.

My objective is to have one of two sets of control buttons appear given the combination of inputs in two separate cells.

There are three conditions:
1. The sales price is greater than zero and the system type chosen is "S".
2. The sales price is greater than zero and the system type chosen is "F".
3. Neither condition 1 or 2 is met.

If condition 1 is met, three control buttons appear: a button that opens up a new PO form tab in the workbook, a button that opens up a new spec sheet tab for "S" systems in the workbook, and a button that runs a print screen macro for that "S" system spec.

If condition 2 is met, three control buttons appear: the same PO button again, and two buttons for the "F" systems.

If neither condition is met then all buttons remain hidden.

My sample sheet is attached.
The two variables are the dollar amount appearing in cell C2 and the selection chosen in cell C3.

I appreciate any input.

Thank you.

~MB
 

Attachments

Last edited:
Top