List box is not working

[CAMDEND]

I have a developing an application. In this particular application I have used List box which is used to populate the database table. there are total 4 columns associated. I wanted to double click on any of the row so that I can capture any of the column data. However I cannot find which row has been double clicked? Let me know if you are having any specific information to get the requirement of mine. Thanks a lot in advance.

[Dwarner]

Well looking at the situation which you have mentioned over here I am suggesting following code to get the requirement of yours.

MyLabel.Text = MyListbox.Cell(Row, Column)
'Row gets the row taken from the event
'Column gets the column taken from the event

It will used to display column row1 on the label which is names as MyLabel.

[Author]

As far as I know List box is having double click event. Any user can double click on the List box. Also I wanted to share something which will give you a light shed on this particular matter. The indexes of the cell which has been doubleclicked is not passed rather you will be able to find the indexes by untilizing the RowFromXY and ColumnFromXY methods. So you should try the thing which I have mentioned over here.

[Jacques25]

You can use the following code which is used for the double click event of the List box so that you will be able to deteremine the indexes which has been double clicked by the user.

Dim row,column as Integer
row=Me.RowFromXY(System.MouseX - Me.Left - Self.Left, System.MouseY - Me.Top - Self.Top)
column=Me.ColumnFromXY(System.MouseX - Me.Left - Self.Left, System.MouseY - Me.Top - Self.Top)
MsgBox "You double-clicked in cell "+Str(row)+", "+Str(column)

[CAMDEND]

Well thanks a lot for the prompt replies of yours the double click option is working fine. It is displaying the coordinates of the mouse pointer. What thing should I use if any of the cell is being highlighted? Also there should be something which will allow me to get the row number. Let me know if you are having idea to get the requirement of mine. Anyway thanks a lot for the prompt replies of yours.

[Jacques25]

After looking at the post I have done little bit research work and I have found that you need to make use of ListIndex. Also you can make use of the same on the double click event. For eg If you pressed keydown event then you should use the following code.

if key=chr(13) then
    msgbox str(me.ListIndex)
  end if

So try the same and let me know whether it was useful to you.