Hi, I have a userform which populates a listbox (also in the form). Items in the listbox can be selected. This repopulates the form with the info of the item selected in case the user wants to edit an existing item.
The listbox "lstMileStones" has 3 columns: txtMile.Value (name in text); txtCompDate.Value (date in text); chkCompleted.Value (y or blank)
Items in the listbox get populated like that:
I would like to find a way to sort the items in the listbox BY DATE (i.e. second column) whenever an item is added to the listbox.
Any way to do that directly in the VBA code?