De: tom Ogilvy Objet: Re: Sorting list box entries in Excel Date : mardi 12 octobre 1999 15:31 Here is a method: http://www.j-walk.com/ss/excel/tips/tip47.htm Here are some other things to look at: http://support.microsoft.com/support/kb/articles/q133/1/35.asp XL: Using a Visual Basic Macro to Sort arrays in Microsoft Excel http://support.microsoft.com/support/kb/articles/q142/1/12.asp XL: Sample Macro to Sort List Based on Custom Sort Order http://support.microsoft.com/support/kb/articles/q136/1/46.asp XL: VB Macro to Sort Custom List on First and Second Keys Regards, tom Ogilvy MVP Excel Andy Cotgreave wrote in message <#cplkDLF$GA.261@cppssbbsa05>... >Hi, > >In VB, I can set a list box's Sorted property to true to make sure all >entries are listed alphabetically. >In Word, I can use WordBasic.Sortarray to sort an array, then add the array >to a list box to get them sorted alphabetically. > >How do I do the equivalent in Excel VBA? I want a list box, which will >contain a list of files, to be sorted alphabetically. > >Thanks! >Andy > >