Alphabetize items in list box?

**Nitefox** · 02-15-2014, 06:59 PM

I am currently using the following code to populate two list boxes (lbUnitList, and lbPOList) on a userform:
How can I get the items in the lbUnitList to show in alphabetical order based on the data in Column 1?

Please Login or Register  to view this content.

**MarvinP** · 02-15-2014, 07:16 PM

Hi Nitefox,

Why don't you sort the two lists where they are on the sheet. Then you don't need to do it using VBA, which is a lot harder. Then you simply need to show the range of (already sorted) cells in your listbox.

**Nitefox** · 02-15-2014, 07:41 PM

Its not that easy, the sheet contains about 5,000 records, and about 400 get added weekly. They are organized by date. It has to be done by VB.

**MarvinP** · 02-15-2014, 09:39 PM

You need to show us a sample sheet for much of any help. Writing VBA without seeing what it relates to is a waste of time (for me at least).

**Nitefox** · 02-16-2014, 05:28 PM

I have uploaded my workbook. The userform is loaded by the Active Equipment button at the top of the ReturnData page. I would like both the top and the middle list boxes to be listed Alphabetically/Numerically.
Thanks,
James