Alphabetize Combobox Items

I have a significant number of comboboxes on a multipage userform. Almost all of them are populated dynamically (it takes the user choice from one combobox, looks for that value on the spreadsheet and if it finds it, it takes whats in the next column and adds it to another combobox). This works great.

My problem is that all the items in these other comboboxes are not in alphabetical order. I'd like to find some code that will work for all my comboboxes so that I don't have to have the same code over and over again for each field.

I found the code below and that works to alphabetize the dropdown, but I still have to use it over and over again and change it for each fieldname (in red). I tried to use a variant and just make the value the same as each fieldname before it calls the sub and whats in red below was just my variable but that just crashes my excel.

Please Login or Register  to view this content.

If you have something better to alphabetize all the comboboxes or can somehow work with what I've found, any help would be greatly appreciated!

Why not just sort the row source for each combo box?

Maybe like this:

Please Login or Register  to view this content.

It surely needs some error checking.