Adding listbox / combo box properties on flexgrid control

Hi all,
I'm looing for a solution to implement listbox / combo box into a flexgrid control.

In my program, a table or form will display a table or form like that to allow user input data.
I choose flexgrid since it seem easilest to used. The flexgrid should have number of rows and
fixed column, 4 let say. The 1st and 2nd column is considered for text input and 2 other is for
number. . User shound only input defined text, eg: "apple", "orange" and "banana" in 1 st and
"boy" or "girl" in 2nd column, let say. The progame will count the total based on column 3 and 4
for "apple", "orange" "banana", "boy" and "girl", so they cannot be mispell.

For user convience, I consider fir listbox / combo box properties in column 1 and 2, if possible.
When user click any cell in column 1, it will list "apple", "orange" and "banana" and user only need to click
the item they want, no need to type. Column 2 is in the same case.

Can any one show me how to do this? If not possible, are there any altnerative solution?
I've considered using control array of combox and textbox and arrange them into a table. But the drawback is due to the screen
and form size, a limited row can be placed, let say, I can place 20 row on the form and no more room for the 21st one.


|-------------------|--------|------|------|
|apple/orange/banana|boy/girl|number|number|


Thank you

A new on VB

Sodium
15/2/2000