DBgrid Problem in VB5

[BillSteele]

I have a Grid .I have the data in it and I can output the Entire Record into variables
and use the data. What I want to do is assign a variable to a specific cell(box) when the user clicks on it and output it that way.
Help me please

[RogerH]

Hi Bill,

see code below (from MSDN)


Private Sub DBGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
' Print the Text, row, and column of the cell the user clicked.
Debug.Print DBGrid1.Text; DBGrid1.Row; DBGrid1.Col
End Sub


To assign variables to each cell you could create a 2-dim array that you access with row and col.

Happy New Year
Roger

[BillSteele]

Excellent Roger : Thankyou

And a Happy new year to you too.