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
|