Sorting combobox

[Lars Brownies]

Of an Excel file I'm reading its tab names into an Access combobox using
additem. Since the Excel tabs are not sorted, is it possible to sort the
combobox programmatically?

Thanks,
Lars

 

[Tom Wickerath]

Hi Lars,

What about the possibility of reading the tab names into an array, then sort
the array, and use it to feed your listbox using the .additem method. There
are lots of hits for a Google search on "sort array vba". Here is one of them:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=103


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Lars Brownies]

Thanks. It partly works. If a tab name has a space in it, the name is
surrounded by a quote ('). If there are tab names with and without a space,
this messes up the sort order.

Lars

 

[Lars Brownies]

Thanks Tom. I'll check it out.

Lars

Hi Lars,

What about the possibility of reading the tab names into an array, then
sort
the array, and use it to feed your listbox using the .additem method.
There
are lots of hits for a Google search on "sort array vba". Here is one of
them:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=103


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Lars Brownies]

Excellent! And there are no issues with spaces, quotes, etc. Thanks.

Lars