Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Visual Basic
I downloaded Visual Basic scripts. Aim is to enlarge part of the XYgraph (zoom). This is done by drawing a rectangle with the mouse. The selection becomes the the new axes.
However in my version this selection doesnot work.
Here a piece of the code.
Private Sub Chart_MouseDown(ByVal Button As Long, ByVal Shift As Long, ByVal x As Long, ByVal y As Long)
If Not ZoomEnabled Then
Exit Sub
End If
Application.CommandBars("Drawing").Controls("Rectangle").Execute
End Sub
** Since I cannot draw a rectangle,
What could be the solution? Ican send the excel work file if sombebody is interested.
Thanks in advance Paul
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data