UserForm + Dropdown

[Paulo]

hi,
I am able to make a drop down form $a$1:$a$4
it would show me something like this

-----V
apple
apple
grape
peach


what I would like to know if I am able to use the array list that excel uses
on its autosort

wich would be exacly the same but with no repetition.

or would I need to make a function that has a sorting augotithm that feels
my own array? and use the array on the drop down.

I worry about the second option because my sheet has 45.000 lines and about
different values 133 that might be slow

 

[Dave Peterson]

John Walkenbach shares how to do this -- but with a listbox.
http://spreadsheetpage.com/index.php/file/unique_items_in_a_listbox

It's not too much different.

 

[Paulo]

is a hashbox more efficient than this?

John Walkenbach shares how to do this -- but with a listbox.
http://spreadsheetpage.com/index.php/file/unique_items_in_a_listbox

It's not too much different.

 

[Dave Peterson]

Maybe. Maybe not.

I don't know what a hashbox is <bg>.