Modify a list of labels on a worksheet if they are the ones selected

[nemmi69]

I have a number of labels on a worksheet that are to start with the background gray and if the user selects from a list of their names they will change to green. The problem I am having is that I can get the names of the labels but then cannot reference them to change their colour.

Please Login or Register  to view this content.

Neither of my tries have worked, any ideas?

[nemmi69]

Now tried

Please Login or Register  to view this content.

with no success

[nemmi69]

No takers on this?

[nemmi69]

Well this doesn't error but doesn't seem to do anything

Please Login or Register  to view this content.