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


--
jocke
------------------------------------------------------------------------
jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766
View this thread: http://www.excelforum.com/showthread...hreadid=471671

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


--
jocke
------------------------------------------------------------------------
jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766
View this thread: http://www.excelforum.com/showthread...hreadid=471671