ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ListBox Property where 'focus' triggers selection (https://www.excelbanter.com/excel-programming/429435-listbox-property-where-focus-triggers-selection.html)

Tony Bender

ListBox Property where 'focus' triggers selection
 
Many of my applications have ListBoxes where the user makes a mouse-
click to record their selection. Is there a property within the
ListBox control that sets the 'focus' to record the selection, in
addition to a mouse-click?

For instance, the user does not have to scroll through the entire list
of selections in the ListBox, they can simply type the first letter of
the name they are seeking. But then they have to click on a different
name and then click back on the name they wanted in the first place in
order to record their selection.

Thank you,

Tony

Patrick Molloy

ListBox Property where 'focus' triggers selection
 
you're thinking of a combo box.
you can make this happen for a listbox if you add a textbox and use the
entered text as a filter for the listbox.

http://www.xl-expert.com/listbox_with_filter.htm


"Tony Bender" wrote in message
...
Many of my applications have ListBoxes where the user makes a mouse-
click to record their selection. Is there a property within the
ListBox control that sets the 'focus' to record the selection, in
addition to a mouse-click?

For instance, the user does not have to scroll through the entire list
of selections in the ListBox, they can simply type the first letter of
the name they are seeking. But then they have to click on a different
name and then click back on the name they wanted in the first place in
order to record their selection.

Thank you,

Tony




All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com