Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Data Labels | Excel Worksheet Functions | |||
Conditional Series Labels in Charts | Charts and Charting in Excel | |||
Chart Labels - Conditional Formating | Charts and Charting in Excel | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Formatting - Data Labels | Charts and Charting in Excel |