Embedded ListView

[jstevens]

If I select an item from an "Embedded Listview" is there something similar to a change event?

I know how to use Listviews on a Userform and have been evaluating an "Embedded Listview" approach.

Something simple such as having a message box appear for the selected item of the Listview.

[HansV]

A ListView control has an ItemClick event that fires when you click on an item.
The event procedure goes into the worksheet module of the sheet on which the control is embedded.

Code: Select all

Private Sub ListView1_ItemClick(ByVal Item As MSComctlLib.ListItem)
    MsgBox "You clicked on " & Item.Text
End Sub

[jstevens]

Thanks Hans!