Private Sub ListView1_Click(): How to get column value from the row

[inddon]

Hello There,

I have a ListView created in a UserForm. I would like to have the following when the user click on the ListView row:

1. To get the value of 3rd column

Tried the below code, in vain:

Private Sub ListViewMaster_Click()
'MsgBox ListViewMaster.ListItems(1).SubItems(1)
MsgBox ListViewMaster.FindItem(3).ListSubItems  'ListViewMaster.ListItems(1)
End Sub

Could you please advise how could I achieve this?

Thanks
Don

 

[Deepak]

Hi,
replace with it & check.

MsgBox ListViewMaster.Column(2)

 

[inddon]

Hi,
replace with it & check.

MsgBox ListViewMaster.Column(2)

Hello Deepak,

Thank you for your reply.

It gives an error "Method or data member not found".

Regards
Don

 

[Deepak]

Pls upload the sample file.

 

[inddon]

Pls upload the sample file.

Hello Deepak,

The solution which you proposed is related to ListBox. This one is for a ListView

Just made up the below solution, if you know the below could be improved in a easier way, please let me know:

ListViewMaster.SelectedItem.ListSubItems.Item(1).Text

Regards
Don