VBFlexGrid Control (Replacement of the MSFlexGrid control)

[Krool]

I’m using VBFlexGrid Control 1.4 OCX.

My original form had 10 labels, each with a editable combo box on the right of them. Each label displayed the name of a category / field and the combo held the available values for that category / field. I want to replace this with a grid where the categories/fields are listed in the first (fixed) column, and the combo’s are showing up in the second column.

The ColComboMode in combination with FlexComboModeEditable looked interesting, but then I found out that the all cells in the column will have the same combo values.

Is there a way for each cell to have it’s unique combo?

For individual combo on each cell you need to handle the BeforeEdit event and set the ComboMode (not ColComboMode) and ComboItems depending on your row.

Btw, I recommend to update to 1.8 OCX.

[PietroV]

Hello, do you know if it is possible to make the grid with hierarchical levels, so that a certain amount of rows can be group and collpased ?

Thanks again for this great control.
Pietro

[Erwin69]

Hello, do you know if it is possible to make the grid with hierarchical levels, so that a certain amount of rows can be group and collpased ?

Thanks again for this great control.
Pietro

I created this by adding an extra column and using a + and - text with a colored background to show the expand / collapse "button". Then use the CellClick event to see if the user wants to collapse or expand. Collapsing is done by hiding the rows (Rowhidden(Row) = True)

[PietroV]

Thanks Erwin, it is a nice idea, and I will experiment.
Unfortunately I cannot get the attachemnt. can you please check it ?
Thanks

[Erwin69]

Thanks Erwin, it is a nice idea, and I will experiment.
Unfortunately I cannot get the attachemnt. can you please check it ?
Thanks

Redid the image. It is now visible in the original post.