list box sorting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AndyB - 09 Apr 2007 06:40 GMT

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

Reply to this Message

Helmut Weber - 09 Apr 2007 09:26 GMT

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

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

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

Reply to this Message