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.
Here is the Excel file.
Thanks in advance!
Cheers,
Marina
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.
Here is the Excel file.
Thanks in advance!
Cheers,
Marina
