Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Listbox property for selection to appear at top

Status
Not open for further replies.

brettboy

Technical User
Joined
Apr 11, 2003
Messages
1
Location
US
I've created a listbox which sources a very large list of data. It's got 3 columns, and the vertical height is large enough to fit 16 viewable records into the box. I've set the MatchEntry property to Complete to enable the user to type a certain selection after clicking into the listbox. However, upon typing the first few letters of a name, the selection always appears as the lower record at the bottom of the box. Is there a specific property or code which will allow the selection to appear at the top of the box (the 1st of the 16 viewable records) whenever the user clicks into the listbox and types the first few letters of the name?

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top