What event to detect click on UserForm ListBox?

D

Don Wiss

I have a UserForm. It has a ListBox. MultiSelect is enabled. I want to be
able to detect a selection, so I can then set the focus to one of the
buttons. A "ListBox_Click()" macro doesn't fire when you click on a
selection. So what event does capture a click? (Using xl2002.)

Don <www.donwiss.com> (e-mail link at home page bottom).
 
D

Doug Glancy

Don,

It looks like the Change event fires whenever a selection is made.

hth,

Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Click on userform transfers to lisbox below 1
Firing Event in another user form 1
listbox click event question 4
Userform Listbox selection change 2
Multi-select listbox - mousedown event 2
Multi listbox change event - selected or deselected 6
Setting focus on User Form Listbox 4

Top