How to get data from ListView of a specific column

[Toeblake]

Hi everyone, I have searched and tried some stuff but nothing is working. Here is what I whant to do :

Goal : When I clic on CommandButton1, the variable A (Date) = data from ListView1 Line X column 2 and the variable B (string) = data from ListView1 Line X column 3.

Info :

- To find X, the user select a line on the ListView1 with a CheckBox in the first column. The Checkbox can be removed... If I can retreive the same info with the highligted line by user. But selecting a line trend to "unselect" by itself, so I'm not sure if this is the correct method to retreive the note selected by the user.

- The data in the ListView1 is from the workbook sheet 2

- Sadly I cannot use DataGrid for this project.

Thanks for all your help!!!

Toeblake

 

[Toeblake]

Solved!!!

FYI: Using ListView1_DblClick() event with ListView1.SelectedItem.Index in sub.

Thanks