how to bring required cell of msflexgrid within the viewable screen

[imrankhaldi]

i have populated msflexgride with perticular data, now on command buttun evend I want to search text from the gride. Coding duly seached but if the required text is below the screen then it does not scroll automatically so that searched item can be viewed. I have following code which search and color the text but does not scroll automatically to come the text in viewable area. Please advise any help.

If Gridbooking.Text = TextToSearch Then
Gridbooking.CellBackColor = vbYellow
ifornextitem = i
Exit Sub

End If

[Bobbles]

   MSFlexGrid1.TopRow = 5
   MSFlexGrid1.LeftCol = 7

[imrankhaldi]

i have changed my code as


If Gridbooking.Text = TextToSearch Then
Gridbooking.CellBackColor = vbYellow , ' its mean it text matches then change its color as yellow

gridbooking.toprow = 5
gridbooking.leftcol = 7

end if

but it has no effect our code. it just searches the relevant text, change its color but do not bring it to viewable screen area. please help.

[Bobbles]

Just woke up.
I used the flexgrid for a few years, then about 10 years ago I switched to the free SGrid2.
It has a method for doing what you want, but that equivalent is not present in the flexgrid (not the same name).
I will knock up an example (for myself with enough data for me to experiment with), and I will find the command, if it kills me

Never fear, Rob is near.

[Bobbles]

Are you using the MSFlexgrid or the MSHFlexgrid ?

I just cannibalised a Database loading project I had (not bound), and the TopRow and LeftCol worked for me. Both scrollbars have scrolled, and the desired cell is visible.
I will knock up a clean new version (no DB), and with clear cell identifiers, and attach it.
I am using the MSFlexgrid, until I hear different from you

[Bobbles]

Yup, my simple example is working, and is attached.

Are you using MSFlex or MSHFlex ?
My example is using MSFlex

Are you using binding ?

What is different between your project and mine ?

[imrankhaldi]

Sir, you are absolutely right, your example is working properly. There is slight mistake at my end ie i am uing MSHFLEXGRID instead o MSFlex. Please advise what i should do now. I cannot change the gride because in my application lot of working has already been done.
Thanks a lot in advance.
Imran

[Bobbles]

OK, I will try using the MSH grid

[Bobbles]

The attached is working for me.

Are you binding ?

[imrankhaldi]

Thank you sir, now it solved.
Kind regards.
Imran