+ Reply to Thread
Results 1 to 4 of 4

Hide/Unhide Command Button based on multiple cell values

  1. #1
    Forum Contributor dagindi's Avatar
    Join Date
    06-02-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    295

    Hide/Unhide Command Button based on multiple cell values

    I found a thread that shows how to Hide/Unhide a command button based on a single cell value, which I changed to the following:

    Please Login or Register  to view this content.

    I wanted to change this further so that two different cells have to have info before the command button appears. I tried a few different variations in the if Range part of the code but kept getting a an error.

    Is it possible to have the range setup as two different cells before unhiding the command button?

  2. #2
    Forum Contributor dagindi's Avatar
    Join Date
    06-02-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    295

    Re: Hide/Unhide Command Button based on multiple cell values

    I was able to find and modify some code that works better than what I was using earlier but I still cannot figure out how to code this so that two cells need to be filled in before the form button and arrow appear:

    Please Login or Register  to view this content.
    Thanks in advance for the help.

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Hide/Unhide Command Button based on multiple cell values

    Hi dagindi;

    I don't know anything about Shapes("Straight Arrow Connector 1"), so I left that part alone.
    Assuming that the 2 cells that need to have something in them are "B7" & "B8" (change to correct cells).
    Please Login or Register  to view this content.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

  4. #4
    Registered User
    Join Date
    10-28-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Hide/Unhide Command Button based on multiple cell values

    Could this be taken to three cells input by adding a rCell3 range?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1