additem to combobox with an array

J

jocke

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 t
add more columns to the combobox it wont work anymore.

tips anyone?

tia jock
 
D

Dave Peterson

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
 
J

jocke

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

thanks a lot

/jocke
 
Top