Forum Discussion

darshan_gandhi's avatar
darshan_gandhi
Occasional Contributor
11 years ago

MSFlex Grid issue

Hi, I am working on a Windows based application designed in VB6. We are having a grid which is a MSFlex grid and inside that grid we have a ComboBox (in each cell) to select a specific value...
  • murugans1011's avatar
    murugans1011
    11 years ago
    As this grid is not supported there is no builtin method to click cell. however u can find the coodrinates of cell click onthe paricular celll. here is the sample code



       Msflexgrid.setfocus

        Msflexgrid.row=1   'row Value

        Msflexgrid.col=1   'ColumnValue



            'to calculate the coordinates of the cell



            x=Msflexgrid.CellTop+form.Top

            y=Msflexgrid.CellLeft+form.Left



            'to convert twip into pixels



            twip_pixel_ratio = form.ScaleWidth / form.Width

            x = x/twip_pixel_ratio

            y = y/twip_pixel_ratio





    Call Msflexgrid.Click( y ,x)  'Clicks the 1st cell

murugans1011's avatar
murugans1011
Regular Contributor
11 years ago
Hi, In my scenario each cell contains textbox. our developers created in such a way for user to enter text in the field. so if i click on the cell the textbox will be visible then i will enter text after pressing enter key record will be updated in grid.



   but in ur case it may be different. so u hav find how u manuall enter text in grid. so without knowing this, cannot able say how to insert record in grid. for input u can use  'keys' method to enter text in field. pls see the attached screenshot how textbox is visble in grid cell