DataLabels: Setting fill transparency in VBA.

Simple query.

I can change the font colour, style, and fill colour, I just can't seem to change the Transparency.

Please Login or Register  to view this content.

Everything else works apart from that Transparency line. It's also worth noting that the transparency can be changed within Excel in the "Format DataLabels" properties window.

50% transparent Red data labels

Please Login or Register  to view this content.

Brilliant. Similarly, how would I set a shadow on the text in the Data Labels?

Also related, where do you find this sort of info? Is there something I can refer to when trying to find paths like "Format.Fill.ForeColor" etc. I was trying out random combinations like "Fill.Color" and tried Googling to no avail.

Object browser and help.

Please Login or Register  to view this content.

Thanks again.

I don't know if I should start a new thread for this and mark this solved; but I used the object browser to find DataLabels, and then in that class I found Format, but I didn't know how to find out what could come after format.. I'm not sure how to explain it, don't know the terminology, but hopefully you can understand what I'm trying to say.

If you click the DataLabel > Format property you should see in the Property panel at the bottom

Property Format As ChartFormat

Click ChartFormat to move deeper into the Object Model

Oh, I see. Thanks anyway, always good to learn something new.