Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? I've referenced Chip Pearson's site and he shows the "ReverseArrayInPlace" procedure but I'm not understanding how it works. http://www.cpearson.com/excel/VBAArrays.htm Thanks for your help. -- John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reverse a function to return the array? | Excel Worksheet Functions | |||
search an array in reverse (bottom to top) order | Excel Discussion (Misc queries) | |||
How to reverse data in an Array | Excel Programming | |||
Reverse numerical values | Excel Worksheet Functions | |||
how to reverse a range/array? | Excel Worksheet Functions |