OLE chart window sizable with form

[elpck]

Hi all,
this is the situation: I have a OLE chart window which contains an excel chart. This OLE is in a form which I set sizable. When the program plots the chart I would like to expand both the form and the OLE together (I mean, I want to expand the chart).
I tried to use this code:


Private Sub Form_Resize()
OLE.width = Form.width
OLE.height =Form.height
End Sub


but it does not work.

[LaVolpe]

Private Sub Form_Resize()
    On Error GoTo ExitRoutine
    If Me.WindowState <> vbMinimized Then
        With OLE1
            .Move .Left, .Top, Me.ScaleWidth, Me.ScaleHeight
            .SizeMode = vbOLESizeZoom
        End With
    End If
ExitRoutine:
End Sub

There are 4 vbOLESize[xxx] constants. Try each one out