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
Printable View
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
Hi Bill,
see code below (from MSDN)
To assign variables to each cell you could create a 2-dim array that you access with row and col.Code: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
Happy New Year
Roger
Excellent Roger : Thankyou
And a Happy new year to you too.