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:
[code]
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
[/code]
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.

[Author]

Posts