Fill combo or listbix with formula

[rhombus4]

Using below
I can fill combobox2, but when I try to use a variable or a value from a combobox or even a value from a textbox I can't get it to work
I get run time error 381

Combobox2.list = evaluate("filter(e2:E12, f2:f12 <> ""red"")")

Combobox3.list = evaluate("filter(e2:E12, f2:f12 <> myvar)")

Combobox4.list = evaluate("filter(e2:E12, f2:f12 <> combobox1.column(0))")

Combobox4.list = evaluate("filter(e2:E12, f2:f12 <> textbox1)")

Also would it be possible to load the formula to an array and fill with the array

 

[Akuini]

Try:

Combobox3.list = evaluate("filter(e2:E12, f2:f12 <> """ & myvar & """)")

Combobox4.list = evaluate("filter(e2:E12, f2:f12 <> """ & combobox1.Text & """)")

Combobox4.list = evaluate("filter(e2:E12, f2:f12 <> """ & textbox1.Text & """)")

 

[rhombus4]

Thanks akuini. Easy when you know how.
Is this the best way to add via a formula if you don't want to add from a range within the book

Also would it be possible to load the formula to an array and fill with the array i e.

Combobox5.list = myarray

 

[Akuini]

Also would it be possible to load the formula to an array and fill with the array i e.

Try:

myarray = evaluate("filter(e2:E12, f2:f12 <> """ & myvar & """)")
Combobox4.list = myarray

 

[rhombus4]

Thanks again

 

[rhombus4]

Sorry me again.

After further testing It seems to work fine when filling from 1 column, however if the combo is 2 columns

Again it's fine if 2 results from evaluate e.g.
Red dog
Red cat

However if I only get one result from the evaluate it appears on 2 rows e.g
Red
Dog

Should appear as Red dog

Also get 381 error for no results
Formula using below

.list = evaluate("filter(e2:f12, f2:f12 <> """ & myvar & """)")

 

[rhombus4]

Bump