additem to combobox with an array

hi, i'm trying to add itemns to an multicolumn combobox (3 columns), using an array.
if i just try to add 1 column there is no problems, but when i try to add more columns to the combobox it wont work anymore.

tips anyone?

tia jocke

Did you change the .columncount property?

I made a small userform and picked up some values off a worksheet to create the
array and this worked for me:

Option Explicit
Private Sub CommandButton1_Click()
Unload Me
End Sub
Private Sub UserForm_Initialize()
Dim myArr As Variant
myArr = Worksheets("sheet1").Range("a1:e10").Value
With Me.ComboBox1
.ColumnCount = 5
.List = myArr
End With
End Sub



jocke wrote:
>
> hi, i'm trying to add itemns to an multicolumn combobox (3 columns),
> using an array.
> if i just try to add 1 column there is no problems, but when i try to
> add more columns to the combobox it wont work anymore.
>
> tips anyone?
>
> tia jocke
>
> --
> jocke
> ------------------------------------------------------------------------
> jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766
> View this thread: http://www.excelforum.com/showthread...hreadid=471671

--

Dave Peterson

finally, now it works.
i've tried with "additem" like a hundred different ways, never heard about the "list"command.

thanks a lot

/jocke