Listview Row clicked

[AlexanderBB]

I need the row number clicked in Excel ListView control.
Does anyone have a solution ? All I can find is

Getting column index of clicked column of listview

I did not find a native procedure to retrieve the index of the column, the info that is here: ListView1.ListItems.Item (ListView1.SelectedItem.Index) .ListSubItems (HERE) I know how to get the in...

stackoverflow.com

The last message there has some code but it won't work for me.
Error is variable not found on 'Screen'

With hitTest
        .flags = LVHT_ONITEM
        .pt.x = (x \ Screen.TwipsPerPixelX)
        .pt.y = (y \ Screen.TwipsPerPixelY)
    End With

Which is quite right as 'Screen' isn't mentioned. May be connected to instructions in the declarations area which I don't follow.
Can anyone help, thank you.

 

[AlexanderBB]

I tried various methods and spent ages Googling... eventually read somewhere it wasn't supported.
Both these show 1 regardless of what row

Private Sub ListView1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As stdole.OLE_XPOS_PIXELS, ByVal y As stdole.OLE_YPOS_PIXELS)
MsgBox ListView1.SelectedItem.Index
End Sub
Private Sub ListView1_Click()
    MsgBox ListView1.SelectedItem.Index
End Sub

Be good to know what does make it work... and if both row and column can be obtained - although the HitTest works well.
I found it hard to find decent docs for this control, which IMO is one of the best! Especially how the columns can be dragged.

 

[RoryA]

Your click routine works fine for me. If you need column as well then you need the approach you already have; I only mentioned this as you never mentioned column originally and getting the row should be simple.

 

[AlexanderBB]

Wow, how can it work for you and not here? That's very weird... I just tried it on Win 11/Office 2019 and it still doesn't work.
Must be some reason..... pity we can't upload a workbook here.

 

[RoryA]

Do you not have access to something like OneDrive or Dropbox?

 

[RoryA]

Ah, I suspect I know what's going on. SelectedItem (naturally) refers to the currently selected row. If what you are clicking on is not in the currently selected row and doesn't change the current selection (e.g. you click a subitem and you don't have FullRowSelect turned on) then you will just get the same number repeatedly.

 

[AlexanderBB]

No, have never set anything like that up. Perhaps someone else might reply with their results

 

[AlexanderBB]

Ah yes, that might be it. Full row select isn't on or off - it's not references at all.
But if it works like that, wouldn't you have you click twice? The idea is get the row just clicked. Any row.

 

[RoryA]

It's off by default, you have to turn it on. I always do because it means you can click in any column to select a row. I find it really irritating to have that turned off. And no, you don't have to click twice.

 

[AlexanderBB]

Roger... I turned it on and seen it working. Handy to know... thanks.