I have a listbox with multiselect turned off and it triggers a macro which
calls up another form on the click event of the listbox. If I want to turn
the multiselect on, how can I trigger the same macro. Am I forced to have a
button and then use its click event. That is, I select multiple items in the
listbox AND then hit the button?

Thanks

EM

Just went through the same thing and finally found in the small print of the
help files that you do need a separated control to initiate the click event
when using multiselect option. Otherwise, it just sits there and looks at
you.

"ExcelMonkey" wrote:

I have a listbox with multiselect turned off and it triggers a macro which
calls up another form on the click event of the listbox. If I want to turn
the multiselect on, how can I trigger the same macro. Am I forced to have a
button and then use its click event. That is, I select multiple items in the
listbox AND then hit the button?

Thanks

EM