Sort items in Fm20 Listbox using Excel spreadsheet Sort function.
Can decide what sheet, workbook and column, also what order to sort by, ascending or descending.
Was needed yesterday to do sort on fly when user adds item to list
' Function need to put inside UserForm module, to access that Listbox control
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Boldcodes.com
Linkedin Login
ListBoxControlName, Optional Order_Asc1_Desc2 = 1, Optional TempWBName = "This", optional TempSheetName = "Data", Optional TempSheetColumn = "A"
Views 901
Downloads 381
CodeID
DB ID
