run code if anything selected in any listbox

[mcdermott2]

Hello,

I have ten multiselect listboxes on a userform. Is there a way to have code run if anything is selected in any of the listboxes without having to create private subs for each listbox?

I am trying to avoid:

Private Sub listbox1_change()
code...
End Sub

Private Sub listbox2_change()
code...
End Sub

...

Private Sub listbox10_change()
code...
End Sub


and so forth .

[JosephP]

you could create one routine that takes a listbox parameter and then call that from each change event or you could use a class module

[mcdermott2]

Thanks, JosephP! Creating one routine to run on each change event should work. I guess I'm getting tired, that probably should have come to my mind.