How to Getting the Value of the column, and the row of Selected Cell in the MSDBGrid

[vbITJunior]

Hi,
I am populating a MSDBGrid using the ADO control. And i would like to get the row value and the column value of the DataGrid to where i selected the cell into the Datagrid.



Hope u can help me......

tnx in advance..... ur great!!!!



-=-

[DaveKeatley]

I've used the data grid in the past to do that

Private Sub DataGrid1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
 
  RowValue = DataGrid1.RowContaining(Y)
  ColumnValue = DataGrid1.ColContaining(X)
 
  SaveValue = DataGrid1.Columns(ColumnValue).CellValue(DataGrid1.RowBookmark(RowValue))
 
  'do operation with cell value
 
end sub