| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What event to detect click on UserForm ListBox?
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). |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What event to detect click on UserForm ListBox?
Don,
It looks like the Change event fires whenever a selection is made. hth, Doug "Don Wiss" wrote in message ... 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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ListBox Click Event | Excel Discussion (Misc queries) | |||
| Click event on listbox | Excel Programming | |||
| click event on listbox | Excel Programming | |||
| select row in userform listbox with right-click? | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
