UserForm + Dropdown
 

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

UserForm + Dropdown
 

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

It's not too much different.


Paulo wrote:

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

UserForm + Dropdown
 

is a hashbox more efficient than this?

"Dave Peterson" wrote:

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

It's not too much different.


Paulo wrote:

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
.

UserForm + Dropdown
 

Maybe. Maybe not.

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

Paulo wrote:

is a hashbox more efficient than this?

"Dave Peterson" wrote:

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

It's not too much different.


Paulo wrote:

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
.


--

Dave Peterson