I am getting the row index of the selected cell with this code:
row = eventdata.Indices(1);
I can also get the column index by changing the 1 to 2. But I want to be able to get the content of any cell I want in that specific row without the user having to actually click on that specific cell but rather anywhere in that row. Let's say I want to get the data from the first column which in my case represents the ID.
In pseudo code it would look like:
x = getRowOfSelectedCell
field = Indices(x,1);
Say the selected row is 5. The variable field would consist of the value of the cell in the first column in row 5.
Any ideas how to proceed?