Hello, I am very new to IGrid so I tried to find my answer in manuals and other forum post but still can find it so maybe someone could help me out?

I am making a VB program in Excel 2013 and therefore I use a IGrid in a Userform to get data from an SQL query. The IGrid is populated with this data and until so far it works fine.

But the only thing I want is that the user clicks with his mouse on an certain row (Rowmode = True) and then I have to collect 1 parameters from this data by Row-Col value where Col = fixed number.

In VB and also other languages there is mostly an ONCLICK event or something like that. But in IGrid I cannot find it? only an iGrid_AfterCommitEdit event. But this is only fired until so far I tested it when I clicked the enter key?

So the simple question is : how does I fire and ONCLick event to get only a value of one of the IGrid cells by Row,Column value, without changing data or setting the IGrid in an Edit mode?

Parameters until now I selected : Editable = False and Rowmode = True

Thank you in advance for the answer. Kind regards, Elwin

iGrid implements several events related to cell/row selection. One of them is CurRowChange. It seems, it is what you need.

iGrid provides a plenty of properties and events related to cell and row selection. You can find them in the help file. See the Programmer's Guide > Programming Basics > Cells Selection section.

Hello thanks for your answer but still not working.

I implemented the follwoing event but still this isn't fired when changing the rows?

Private Sub iGridWerkbonnen_CurRowChange(ByVal lNewRowIfAny As Long, ByVal lOldRowIfAny As Long)

But I also use the IGrid which comes standard with Excel 2013 and this is version 5.00, build 0086 can it be that this event is not working on this version yet?

iGrid does not come with Microsoft Excel. It can be a remnant from another installation or product using iGrid.

iGrid 5.0 is a very old control. The latest version is 7.5. We recommend that you upgrade to it. To do this, download the latest demo setup package and install it.

As for the problem with the CurRowChange event, we need a sample demonstrating the issue.

Thanks for your advice! THe old version was the issue. Version 7.5 works as expected!