LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Icy Icy is offline
external usenet poster
 
Posts: 10
Default Filiter and Limit selection in Combo box / List Box in the UserFor

I am having a problem to limit the selection display in the Combo box / List
Box. I would like the Combo Box to display a list of result in the drop down
list as user enter value. I have a data base with 2000 entry, it will be
very helpful to limit the record display in the dropdown list.

Example if user type A in the Combo box the drop list will show
Apple
Age
Adam
Ace
Appointment

if user type Ap then only Apple & Appointment with show on the drop down
list.

Kind of like filter, but the result on the drop down list will change as the
input value changes. Could some one please help. Thank you so much.
 
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
Limit to the length of a list in a combo box Fraser B Excel Discussion (Misc queries) 3 February 9th 09 02:44 PM
Filiter and Limit selection in Combo box / List Box in the UserFor Icy Excel Worksheet Functions 0 November 3rd 07 12:42 AM
Combo Box selection only shows bound column info after selection made. Coby Excel Programming 1 October 18th 07 02:04 AM
Populate one combo box based on the selection of another combo box Alex Excel Programming 8 April 19th 07 06:40 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM


All times are GMT +1. The time now is 02:48 PM.

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"