VBA Excel - Getting the value of the first column of a ListView

Question

Dear all,

by this line I'm getting the column x value of the ListView selected row.

Selected_ID = lvwShowUserLog.SelectedItem.ListSubItems(x).Text

The above code line works when x is not zero; in fact when I try to get the value of the first column (having index =0) of the selected row I get this error message:

With this line:

Selected_ID = lvwShowUserLog.SelectedItem.ListSubItems(0).Text

I should get the ID value which is 1: I’m doing something wrong?

Thanks

Answer 1

ListSubItems, as the name indicates, contains only the subitems, i.e. column 1 and higher.

To get the first column (column 0), use

Selected_ID = lvwShowUserLog.SelectedItem.Text