Change and Doubleclick events for the same UserForm ListBox

[Sal Paradise]

I have a UserForm Listbox Called 'PressLossList'. I have a change event for it that works just dandy (wrapped in Sub PressLossList_Change() tags). I also want to have a different event for if it's double-clicked. For that I use this code:

Private Sub PressLossList_DoubleClick()
    
    Dim c           As Range
    Dim TitleName   As String
    
    TitleName = Me.PressLossList.Value
    
    With Worksheets("Opportunities").Range("$C:$C")
        Set c = .Find(TitleName, , xlValues)
        If Not c Is Nothing Then
            Worksheets("Opportunities").Cells(c.Row, 1).EntireRow.Delete
        End If
    End With

End Sub

Any ideas?

 

[Kenneth Hobson]

Choose your events from the dropdown list. The syntax is:

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    MsgBox "DblClick"
End Sub

 

[Sal Paradise]

Ah, I didn't even see the dropdown list until you pointed it out. My apologies for a stupid question with an easy answer. Thank you for the help.