Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you Sort Listbox Values Alphabetically by code?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you Sort Listbox Values Alphabetically by code?
Corey:
You can't automatically get them sorted in a list box but you can add items at specific places. So the easiest way to do it is to sort the items in an array prior to putting them on the listbox. And you can add the array at once. Note for bound items this cannot be done. (sort the bound list.) -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Corey" wrote: |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you Sort Listbox Values Alphabetically by code?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you Sort Listbox Values Alphabetically by code?
Martin has given good advice in emphasizing that items don't have to be
isnerted at the end of the list. Here is some addtional information: This article by John Walkenbach shows how to fill a listbox (or combobox) with a unique list of sorted items. You can use the whole approach or extract what you need and adapt it to your situation. http://www.j-walk.com/ss/excel/tips/tip47.htm -- Regards, Tom Ogilvy "Corey" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort A1 THROUGH F26 alphabetically? | Excel Discussion (Misc queries) | |||
how to sort non-alphabetically | New Users to Excel | |||
sort sheets alphabetically | New Users to Excel | |||
Fill and sort multicol listbox from VBA code? | Excel Programming | |||
sort by alphabetically | New Users to Excel |