Results 1 to 7 of 7

DataLabels: Setting fill transparency in VBA.

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2009
    Location
    UK
    MS-Off Ver
    2007
    Posts
    60

    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.

    ...(select data labels)...
     
    With Selection.Font
    .Name = "Calibri"
    .Style = "Bold"
    .a few more things = whatever
    End With
     
    With Selection.Interior
    .Color = 14136213
    .Transparency = 0.5 '<------- Is this incorrect?
    End With

    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.
    Last edited by AKK9; 09-28-2010 at 10:37 AM. Reason: Solved.
    .
    - AKK9 -

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1