Creating MSFlexGrid inside an ActiveX control

Hi all,

I am having problem in initializing a msflexgrid control inside my activeX control that I am developing.

Here is what I do:

Option Explicit
Private msflexCustomers As MSFlexGrid

Private Sub UserControl_Initialize()
Set msflexCustomers = NewMSFlexGrid
End Sub

And this is what I get:

"Invalid use of new keyword" inside UserControl_initialize method.

I can not find what the problem is.

your help is very much appreciated.

Thank you.

Ramesh

Dim myflexCustomers As New MSFlexGrid

Above comment by victorpendleton does not seem to work for me.

May be I should restate my problem.


I have a MSflexGrid control inside my userControl ( ActiveX ) and I want to initialize it before I can make use of it.

When i do this inside UserControl_Initialize , I get "Invalid use of new keyword".

Basically, This is my question: where do I initialize my msflexCustomers ( MSFlexGrid ) inside my userControl ?


Thank you in advance.