+ Reply to Thread
Results 1 to 3 of 3

Show and Hide Label Controls based on cell on another sheet

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    7

    Show and Hide Label Controls based on cell on another sheet

    Greetings again,

    I am trying to make two label controls (Active-X) behave according to the value of a cell on another sheet. The cell contains a formula that calculates a balance. Since these calculations shouldn't be visible to the user, the calculation sheet is hidden and the only knowledge of the nature of the balance should come from the two labels on the first sheet.

    - If the balance of positive, a "good" label should appear, stating that the strategy is sustainable;
    - If it is negative, a "bad" label appears, stating that the strategy is unsustainable.

    When one of the labels appears, the other one should hide.

    I've tried searching the forum and other forums through Google and came to a code that doesn't seem to be working...

    I am attaching a stripped down example of what I am trying to do (the actual file is too big).

    Would be great if someone can help or point to the mistakes in the code.

    Thanks in advance!

    Cheers,
    Marina
    Attached Files Attached Files

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Show and Hide Label Controls based on cell on another sheet

    Try this, let me know if it works, don't have 2007

    It is the only way I found to do something similar to what you are trying to achieve, it doesn't use labels though
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-13-2011
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Show and Hide Label Controls based on cell on another sheet

    It did the trick, thanks. When the picture is adjusted, it works just like a label.
    Thanks again!

+ 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