help with dynamic combo box

Hello Chia,

Your syntax is wrong in the code below.

Dim productA as Variant 
productA = Range("P2":"P2")
comboBox1.List() = productA

The cell range should be enclosed by a single pair of quotes, like below...

Dim productA as Variant 
productA = Range("P2:P2")
comboBox1.List() = productA

Originally Posted by Leith Ross

Hello Chia,

Your syntax is wrong in the code below.

Dim productA as Variant 
productA = Range("P2":"P2")
comboBox1.List() = productA

The cell range should be enclosed by a single pair of quotes, like below...

Dim productA as Variant 
productA = Range("P2:P2")
comboBox1.List() = productA

Hi thanks for pointing out, that is mistake on my part when i type here. I edited it already.
productA = Range("P2", "P2")
Anyway it still doesnt work with the same error message.