CODEWITHSUNDEEP
vbaeventslistbox
DezyK
DezyK

Reputation: 65

listbox_DblClick() event

I am trying to create an event for a list box multi column list box, so that when the user double clicks on an item it opens up the specified record. I have created and displayed the list OK, but can't get the event to work. the code is:

 Private Sub lstServiceHistory_DblClick()
     frmJobDetails.Show
 End Sub

The click event works OK, it's the dblclick that doesn't. I'm stumped. the error is "Compile error. Procedure declaration does not match description of event or procedure having the same name"

Upvotes: 1

Views: 1527

Answers (2)

basodre
basodre

Reputation: 5770

Try adding:

ByVal Cancel As MSForms.ReturnBoolean

between the parenthesis following DblClick and let us know if that fixes the problem

Upvotes: 1

Rubik
Rubik

Reputation: 1471

Don't forget parenthesis when you call the show method:

Private Sub lstServiceHistory_DblClick()
    frmJobDetails.Show()
End Sub

Upvotes: 0

Related Questions