[RESOLVED] Use Spreasheet control instead of MSHFlexgrid

[angava]

I've had many problems with MSHFlexgrid because of the updates, I already tryed many things, for example I registered it, put the DWord value as 0 in regedit, changed UAC values, etc, and nothing works. I still get the "The subject is not trusted for the specified action" message.

So I decided to replace MSHFlexgrid control for Spreadsheet control.
I use the control in a userform in a Excel file, and the control is only going to display data.

Any comments or suggestions?

[Siddharth Rout]

Just curious... Why not a listview? If it is just for displaying data?

[angava]

I haven't worked much with Spreadsheet or Listview controls, but I believe in this case I would have to rewrite less code using Spreadsheet, specially using Cells() method, but this is just my opinion and as I said I don't much experience with these controls.....any advice is welcomed.
Do you think in the future I may have the same kind of problems I had with MSHFlexgrid if I use Spreadsheet control...
thanks

[Siddharth Rout]

Angava, there is no problem in using the spreadsheet control. It's just that it is more complex than a Listview control...

No you won't have any problems with Spreadsheet control as you had with MSHFlexgrid control...

What exactly do you want to do?

[angava]

I am working in a spreadsheet that makes calculations and displays the data from the calculations, but it doesn't connect to any database.
So far spreadsheet control has worked fine, I just haven't been able to find a method to change the columnwidth during runtime, any suggestions?
thanks again

[Siddharth Rout]

... I just haven't been able to find a method to change the columnwidth during runtime, any suggestions?
thanks again

Private Sub CommandButton1_Click()
    '~~> Spreadsheet1 is the name of the spreadsheet control
    Spreadsheet1.Columns(1).ColumnWidth = 15
End Sub

[angava]

Thanks a lot!

[angava]

ready