excel - Excel 365 ProPlus - VBA - 点对象 - 方法设置属性和获取属性

Question

有谁知道如何使用？是否可以通过这些方法设置透明度？你有文档链接吗？官方文档没有提到这些方法：

https://docs.microsoft.com/en-us/office/vba/api/excel.point%28object%29

Option Explicit

Sub Main()
    Dim ws As Worksheet
    Dim chartObj As ChartObject
    Dim chart As chart
    Dim seriesCol As SeriesCollection
    Dim series As series
    Dim points As points
    Dim point As point
    Dim x As Object

    Set ws = ActiveSheet
    Set chartObj = ws.ChartObjects(1)
    Set chart = chartObj.chart
    Set seriesCol = chart.SeriesCollection
    Set series = seriesCol.Item(1)
    Set points = series.points
    Set point = points.Item(1)

    point.SetProperty "Transparency", 0.5
    Set x = point.GetProperty("Format")
End Sub

标签： excelvba