If you comment this assignment out, can you see any grid actually created inside the box?

Are you sure the ProgID assigned to AxControlId represents the same type as the sec.Control reference?

I have downloaded a FarPoint Spread 8 trial and replaced the "SampleAx.AxNode" assignments in the ActiveX sample project with:

fcx.AxControlId = "FPSpreadADO.fpSpread.6"

and also changed the event wrapper with the following:

Public WithEvents Control As FPSpreadADO.fpSpread
Public Parent As Form1

Private Sub Control_Click(ByVal Col As Long, ByVal Row As Long)
    Parent.sax_Start
End Sub

It works fine and successfully shows the message box when a cell is clicked. Could you try that ProgID in your project?

I mean you have used a different ProgID "FarpointADO.fpSpread.6" than the one I've found in the registry after installing FarPoint - "FPSpreadADO.fpSpread.6". Do you perhaps have two different versions of the spread control?

i have tried everything several times, even i downloaded the trial version you used and make all the trials on different machine but the results are the same. (err msg Type mismatch)

i looked in the Locale window in vb 6 and i found the box.AxControl type is Object/fpSpread so everything seems great. but when i try to set the variable to the box.AxControl i got type mismatch error.

Also, i tried completely new projects and always that error.

do you think the error is in certain settings or declaration or something?

or can you send me the project that you did yourself?

Thank you alot for you support.

Greaaaaaaaaaaaaaaat !!!

Your project works perfectly. Thank you a lot.

But i have may be a silly question, In your project Although i don't see that you added the fpSpread as component (i don't find it in the ToolBox) but i can still find the reference library in the Event Wrapper Class.

1) When i tried to add the Component from (Project> Components) i received the err msg "Name Conflict with existing module", so how can this happen and where is that module?

2) How did you add the fpSpread to the project?

3) when i made a completely new project but added the fpSpread normally from the components dialogue, the type mismatch error appears as usual, so i think the trick was in adding the fpSpread to the project, do you have an explanation for this?

This will really help me in adding other controls.

Thank you alot for the great support.

Really, Thank you so much for your support