list box sorting

A

AndyB

I have a listbox in a user form that is populated by records from and ACCESS
table

How can I get that lisbox to display the records alphabetically? I want to
be able to select an entry. What is the way to get the listbox to respond
similarly to the fill in bars you often see with many form fields that you
fill in that will show you the matching choices (eg the address bar in IE)

Thank you in advance
 
H

Helmut Weber

Hi Andy,

why VBA as opposed to VB still doesn't support sorting
nobody knows. Whithin the last ten years it was possible
to add character formats like "marching black ants" and
"marching red ants" to Word's features. But sorting a listbox, no!
You got to implement a sorting algorithm yourself.

see: http://tinyurl.com/2pf8cm

and don't stop reading after bubblesort,
but have a look at Howard's site.

http://www.standards.com/Sorting/SortPerformanceComparison-Description.html

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
 
Top