Thanks Helmut, OssieMac, and Rick for your time and help - all examples
worked perfectly.

--
John






"Rick Rothstein (MVP - VB)" wrote:

I have a one-dimensional array containing values that load a listbox. I
would like to reverse the order of the values as they appear in the
listbox.
The array is called UniqueValues and I'm loading the listbox via the
following:

For Each Item In UniqueValues
frmTrace.ListBox1.AddItem Item
Next Item

Is there a way to reverse the values without dropping the values into a
worksheet, resorting, and reloading?

Use the same code you have, but add the optional argument to the AddItem
method...

For Each Item In UniqueValues
frmTrace.ListBox1.AddItem Item, 0
Next Item

Rick