Sort data in a userform combobox

[Honeythunder]

Hi all,

I am currently frustrated over how to sort a list in a userform dropdown box. I have only 2 sheets which are SALES and STATEMENT. The statement sheet contains userform to populate the the results of my report. My problem is that the dropdown for the customer list does not show in alphabetical order. This is not an issue when there are only a few sales but gets very frustrating with large numbers of sales.

I have attached a sample copy of my spreadsheet in the hope that someone smarter than me can help.
Thanks

[mehmetcik]

I am not sure if this will work in your version of Excel.

Try changing your Userforn UInitialisation Event to:

Please Login or Register  to view this content.

[nankw83]

Hi Honeythunder,

I remember helping you on this file in the past ... You can change the UserForm_Initialize with the below

Please Login or Register  to view this content.

Edit : Sorry @mehmetcik, I was working on the file as well & didn't see your post until I posted mine & the page was refreshed

[Honeythunder]

Thank you Mehmetcik for your quick reply. Unfortunately it did not work for me. I am using excel 2019.

[torachan]

Courtesy of Tom Urtis.

Please Login or Register  to view this content.

torachan

[Honeythunder]

Thank you nankw83, I now get a runtime error and the form does not initialise.

[nankw83]

I am not getting any error Try the attached file

[Honeythunder]

Again, thank you so much nankw83, I have incorporated your solution into my file and all is ok. Your help is greatly appreciated.

[nankw83]

Glad to help & you're welcome

If that takes care of your question, please take a moment to mark this thread as [SOLVED] from the Thread Tools above your first post & consider * Add Reputation to those who have helped by clicking the star icon under their usernames

[Honeythunder]

Many thanks to torachan. Your solution also worked perfectly. I am grateful for all the help given to me on this forum.