Help with a combo box (OrderAlphabetically)

Hello All,

I have an excel doc with a column for CLIENT NAMES.

1 - I would like to populate the names in my USERFROM in a COMBOBOX in order Alphabetically.

2 - If I type a name of the client in the COMBOBOX, for example (Peter), I would like to see all the Peters I already have in the system first.

Can someone please help me with this

Hello John55

I tried your code. Im able to see all the names displayed in the Combobox, but if I type a name that is on my excel sheet, im not able to see displayed how many of these names I already have on it. For example, If I type PETER, I want to be able to see first all the peter's I have on my sheet in orther not to make a double entry

John's code is only for the population of the combo box. Something like this would need to be assigned to a command button on the user form for after you select the name.

Please Login or Register  to view this content.