View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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