Listbox Click event

[scottintexas]

I have a userform on which there is a list box. When the user clicks an item in a multiselect list box I want a total to appear in a textbox on the same form. The problem is that the listbox click event isn't firing. I have a breakpoint set at the click even and it never breaks there.

How is the click event supposed to work?

Please Login or Register  to view this content.

[Leith Ross]

Hello scottintexas,

The Click Event only functions when the ListBox has the MultiSelect property set to fmMultiSelectSingle. When the list box MultiSelect property is set to fmMultiSelctMulti or fmMultiSelectExtended use the Change event to monitor the user's selections. Use the Selected(index) property in a loop to check which items were selected.

Sincerely,
Leith Ross