help with dynamic combo box

[chia0089]

Hi, i want to additems to combobox whenever my userform initialize.
I chose to use the list property as i have a very long list and using .additem not as efficient.
What i want my program to do is go to a particular column, then get any data from that column (excluding the column name) and add it to my combo box.
Basically i think my program logic works, but i am not so familiar with excel practices.

main issue is why this 2 lines of code will fail me:

Please Login or Register  to view this content.

Below is the coding i got.

Please Login or Register  to view this content.

error occurs when my productA list is empty. so i debugged and simplified the code to simulate situation when list should be empty and when list contains 1 item:

Please Login or Register  to view this content.

error occurs when list is "empty".

Please Login or Register  to view this content.

no error occurs when at least 1 item exist.

Btw the error message is
Run-time error '381'
Could not set the List property. Invalid property array index.

Anyone knows why error occurs when productA is set to Range("P2", "P2")? Thanks alot.

[Leith Ross]

Hello Chia,

Your syntax is wrong in the code below.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

[chia0089]

Hello Chia,

Your syntax is wrong in the code below.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.