Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,049
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Listbox Item Focus Kagan Clearwater[_2_] Excel Programming 1 April 5th 07 08:12 PM
Setting focus on User Form Listbox Don Wiss Excel Programming 4 August 26th 06 03:16 AM
Bug in Excel 2000? (CurrentRegion property triggers events) John Coleman Excel Programming 3 September 13th 05 02:22 AM
Runtime error 380: Could not set the List property. invalid property value of listbox jasgrand Excel Programming 0 October 6th 04 09:28 PM
removing selection focus in listbox Craig Wilks[_2_] Excel Programming 2 August 13th 03 12:15 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"