1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. 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


  3. 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

Discussion in 'VBA Macros' started by Matt Burns, Jan 9, 2019.

  1. Matt Burns

    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.


    Attached Files:

    Last edited: Jan 9, 2019
  2. Belleke

    Belleke Active Member


Share This Page