Consulting

Results 1 to 4 of 4

Thread: Have I got the wrong documentation?

  1. #1

    Have I got the wrong documentation?

    Hello everyone,
    Here is a code snippet from the Excel macro book I am reading:
    'Create a gradient pattern in the chart area, changing from red at the top to violet at the bottom
        With ActiveChart.ChartArea.Fill
            .Visible = True
            .ForeColor.SchemeColor = 3
            .BackColor.SchemeColor = 7
            .TwoColorGradient Style:=msoGradientHorizontal, Variant:=1
        End With
    The code runs as expected. I am using Excel 2007. However, when I look through the documentation, I cannot see the Fill method amongst the members of the ChartArea object. I am now wondering if I have an incomplete documentation in my computer. The members of the ChartArea object available in the documentation in my computer are shown below:
    ChartArea Object Members.jpg

    If it is the case that I have an incomplete documentation, please recommend where to get the full documentation.
    Thanks.

  2. #2
    VBAX Regular Beavisx's Avatar
    Joined
    Dec 2013
    Location
    Lugano
    Posts
    9
    Location
    If you go to delevoper and then you open "Visual Basic" , if you click F2 you can acces to the object browser of VBA.
    I found "fill". it is a proprety of the ChartFormat class

    Have a look

    Hope is that you were looking for
    Sorry about my English mistakes!

  3. #3
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    The Fill property of the ChartArea object is deprecated. It's hidden but still works. In theory you are supposed to use Chartarea.Format.Fill instead.
    Be as you wish to seem

  4. #4
    Thanks Beavisx and Aflatoon.

Tags for this Thread

Posting Permissions

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