Show label when cell value

**Svanis75** · 10-15-2010, 02:01 AM

Hello,

This is probably really easy but I can not think how to solve this.

I would like to a label show up only when the letter "C" is displayed in cell B5.

See attached example.

//Svanis

**royUK** · 10-15-2010, 02:12 AM

What label? The simplest solution would be to use an IF formula

=IF($B$5="C","B5 is C","")

**Svanis75** · 10-15-2010, 02:17 AM

I meen the label that says "Follow the instructions".
//Svanis

**royUK** · 10-15-2010, 02:20 AM

Unless you use VBA, which is unnecessary, use the formula & format a cell to act as the label.

**Svanis75** · 10-15-2010, 02:33 AM

I would like to use VBA to show the label. Could you show me how to do that.

Thank´s for your help.

/Svanis

**Svanis75** · 10-15-2010, 05:44 AM

I would like to use VBA to show the label. Could you show me how to do that.

Thank´s for your help.

/Svanis

**Svanis75** · 10-18-2010, 02:39 AM

I found a way to do this with this code:

Please Login or Register  to view this content.

Regards
/Svanis

**royUK** · 10-18-2010, 03:13 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here