View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Conditional format for labels

Hi Jan,

If you wish, you may send me your workbook:

norman_jones@NOSPAMbtconnectDOTcom

(Delete "NOSPAM" and replace"DOT" with a period (full stop))

By all means, delete other sheets and any sensitive data.

---
Regards,
Norman



"Jan" wrote in message
...
Thanks, Norman. Great, fast reponse. The code even seems to make sense to
an
amateur like me ! ;-)

I still seem to be missing out on a detail somewhere, though, as I get the
following message:

'Compile Error: Method or datamember not found'
and then a highlighting of '.Label1' in the line Case 1:
Me.Label1.BackColor
= &H80FFFF ?

I thought this was regards the naming of my label, but it is called
Label1 -
or how can I be sure. I'm just looking in the upper-left corner when
highlighting the label and it says 'Label1'?

Regards,
Jan