Userform Combobox to populate form: Can I change the order of the columns in the combobox?

I put together a solidly working userform that uses data from the worksheet to populate the combobox that would then select the record with which to populate the userform. I was using a named range (also defined in VBA) to do this. However, I now want to use different columns to select from, and I can't seem to get the named range to organize the rows how I want. What I want is column "i" to be the first choice, with column "c" as the second criteria (previous, I used b and c). I have set up the named range to run from c to i, and then set column width for everything NOT "c" or "i" to zero. But how do I make "i" show first? Or is this something named ranges cannot do?

Please Login or Register  to view this content.

This is literally my LAST punchlist item to close out this project, so the help would be greatly appreciated!

I went with romperstomp's solution. With a little tweaking, it worked like a charm. Thanks!

Craig W.

Okay, one more need here... Can I get the Combobox list to sort alphabetically? I've been looking through various forums and trying variations on those solutions, but cannot seem to get where I need to be. Here is the code as it stands, which only sorts in the order on the originating sheet. This is so much simpler using anything other than Excel... But it's what the client wants. (Sorry, had to vent a bit there!)

Basically, I need the sort to be ascending alpha by column 7. Bonus if I can sort by 7, then by 1 without adding too much more code. But since most rows on the sheet will not have more than 3-4 rows per Column 7 (a name field), it's not that vital. Thanks again...

Please Login or Register  to view this content.