Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox Item Focus | Excel Programming | |||
Setting focus on User Form Listbox | Excel Programming | |||
Bug in Excel 2000? (CurrentRegion property triggers events) | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
removing selection focus in listbox | Excel Programming |