How do I refill a userform listbox after a new entry has been added?
This question may have been asked a few times - but I could not find an answer online.
I have created a userform which displays the customer's name and other information. I can successfully amend the data and write it back to the spreadsheet. I've also written a procedure that sorts the name of the customer: It's a named range.
I wish that the listbox is refilled again - without having to close the userform - in such a way that the customer name is sorted from A to Z.
Thanks for your help.
This is the code which is executed when the information is saved to the spreadsheet. What next?