TextBox Rowsource code not working

delta · Mar 11, 2021

below code put in userform initialize but error show is type mismatch. what is correct code
Me.ComboBox1.RowSource = Sheet2!Range("a1:a8").Value

Debaser · Mar 11, 2021

Rowsource is an address, so it would be:

Code:

Me.ComboBox1.RowSource = "Sheet2!a1:a8"

Belleke · Mar 11, 2021

or

Code:

ComboBox1.List = Sheet2!Range("a1:a8").Value

delta · Mar 12, 2021

Do not working.
run time error 438 show
object doesn't support this method or property

vletm · Mar 12, 2021

delta
Duplicated with

what is wrong in code >>> use code - tags

chandoo.org

This thread is closed.