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