Dynamically populate combobox in userform

[edjohns]

Hello again friends,

I am trying to populate a combobox (inside a userform) with 2 columns. Like:
COL 1 COL 2
A 1
B 2
C 3
... and so on.

I am using the list method (although i have tried with additem to no success either). What I need is for the box to display a list like:
A : 1
B : 2
C : 3
... and so on (with the colom and all, although not as important. But ideally, I need to have a separator between each column item in each row)

Here is the code I've have so far:

Please Login or Register  to view this content.

I'm getting strange behaviors, like the box being populated from rows 1 and 2 of the spreadsheet only from the first column.
I am very confused with this.

As always, I appreciate any advice

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.