Open Axis-Dialog

[Anonym]

Hello,
I look for a possibility to open the axis-dialog via VBA. Is there a possibility to open FlexPro-dialogs via VBA?
I need this functionality, because I would like to open the dialog for one diagramm and copy the settings to all selected diagrams.

[Bernhard Kantz]

This is not possible with VBA. But you don’t need to open a dialog to copy the properties of the diagram.

Example:

    Dim oDiag1 As Diagram2D
    Dim oDiag2 As Diagram2D
    '...
    With oDiag2
        .YAxes(1).Scaling.StartValue = oDiag1.YAxes(1).Scaling.StartValue
        .YAxes(1).Scaling.EndValue = oDiag1.YAxes(1).Scaling.EndValue
        '...
    End With

support@weisang.com

[Anonym]

Hello,
thanks for the fast answer. But my problem is not copy the values from one diagramm to another. I would like to give the user the possibility to change the axis-settings in the first diagramm of a selection and copy these settings to the other selected diagramms. If it is not possible to open the dialog I must create an userform with the main axis-settings.

[Autor]

Beiträge